hive語句不是很熟悉，對表聯(lián)合這個基本的都要找半天資料，這里寫下，作為以后的參考：

select a.time_stamp,a.acc_nbr,b.bts_name from (select * from default.tableA where ?start_date >=20170612 and start_date<=20170618 and acc_nbr ="18988888888" a left join (select * from default.tableB) b on (a.bsc=b.bsc_id and a.bts=b.bts_id and a.call_latn=b.latn);

hive表連接語法：

join_table:table_reference JOIN table_factor [join_condition]| table_reference {LEFT|RIGHT|FULL} [OUTER] JOIN table_reference join_condition| table_reference LEFT SEMI JOIN table_reference join_condition| table_reference CROSS JOIN table_reference [join_condition] (as of Hive 0.10)table_reference:table_factor| join_tabletable_factor:tbl_name [alias]| table_subquery alias| ( table_references )join_condition:ON equality_expression ( AND equality_expression )*equality_expression:expression = expression
語法還是要多練習，工具才能熟練掌握。

總結(jié)

以上是生活随笔為你收集整理的Hive表联合查询语句参考的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。