Hive表联合查询语句参考

来源：互联网发布：哪里多淘宝模板下载编辑：程序博客网时间：2024/06/03 23:32

hive语句不是很熟悉，对表联合这个基本的都要找半天资料，这里写下，作为以后的参考：

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

语法还是要多练习，工具才能熟练掌握。

阅读全文

0 0