ParseException Line无法识别附近的输入（＆＃x27;＆＃x27; select'in＆＃x27;从joininsource中

发布于 2025-02-13 08:35:10 字数 415 浏览 1 评论 0原文

我试图在Hive中执行查询并获取错误。我一遍又一遍地检查一下，但看不到任何问题。

select 
a.phone_no,
a.app_name
from 
(select * from (select app_name,phone_no from lc_app_flag) ) a 
inner join 
(select * from (select phone_no,city_id_day,city_id_night,lat_day,lng_day,lat_night,lat_night from TW_FEATS_FIN_LCEXT01 where month_id='202205'  ) b where city_id_day='440100' or city_id_night='440100') c
on a.phone_no=c.phone_no

原文

I am trying to execute a query in hive and getting the error. I check over and over again but I cannot see any problem.

select 
a.phone_no,
a.app_name
from 
(select * from (select app_name,phone_no from lc_app_flag) ) a 
inner join 
(select * from (select phone_no,city_id_day,city_id_night,lat_day,lng_day,lat_night,lat_night from TW_FEATS_FIN_LCEXT01 where month_id='202205'  ) b where city_id_day='440100' or city_id_night='440100') c
on a.phone_no=c.phone_no

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟花肆意 2025-02-20 08:35:10

您错过了别名第一个最内向的子查询。在下面更正SQL-

select 
a.phone_no,
a.app_name
from 
(select * from (select app_name,phone_no from lc_app_flag) subq)  a --inner subquery as subq
inner join 
(select * from (select phone_no,city_id_day,city_id_night,lat_day,lng_day,lat_night,lat_night from TW_FEATS_FIN_LCEXT01 where month_id='202205'  ) b where city_id_day='440100' or city_id_night='440100') c
on a.phone_no=c.phone_no

You missed aliasing first innermost subquery. Correct SQL below -

select 
a.phone_no,
a.app_name
from 
(select * from (select app_name,phone_no from lc_app_flag) subq)  a --inner subquery as subq
inner join 
(select * from (select phone_no,city_id_day,city_id_night,lat_day,lng_day,lat_night,lat_night from TW_FEATS_FIN_LCEXT01 where month_id='202205'  ) b where city_id_day='440100' or city_id_night='440100') c
on a.phone_no=c.phone_no

回复收藏 0 原文

~没有更多了~