Hive Joins详解【left / right / full / left semi】

最新推荐文章于 2022-04-18 17:11:01 发布

Simple_Zz

最新推荐文章于 2022-04-18 17:11:01 发布

阅读量406

点赞数

分类专栏： Hive 文章标签： Hive join

本文链接：https://blog.csdn.net/love284969214/article/details/94335305

版权

Hive 专栏收录该内容

10 篇文章 2 订阅

订阅专栏

Hive官方语法

join_table:
    table_reference  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_table
 
table_factor:
    tbl_name [alias]
  | table_subquery alias
  | ( table_references )
 
join_condition:
    ON expression