HIVE中join、semi join、outer join举例详解

最新推荐文章于 2024-07-29 11:41:47 发布

asd1456732891

最新推荐文章于 2024-07-29 11:41:47 发布

阅读量247

点赞数

分类专栏： hadoop

本文链接：https://blog.csdn.net/asd1456732891/article/details/99619439

版权

hadoop 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

首先，hive中，left join与left outer join等价。
举例子：

hive> select * from zz0; 
111111 
222222 
888888 

hive> select * from zz1; 
111111 
333333 
444444 
888888

hive> select * from zz0 join zz1 on zz0.uid = zz1.uid; 
111111  111111 
888888  888888

hive> select * from zz0 left outer join zz1 on zz0.uid = zz1.uid; 
111111  111111 
222222  NULL 
888888  888888 

hive> select * from zz0 right outer join zz1 on zz0.uid = zz1.uid; 
111111  111111 
NULL    333333 
NULL    444444 
888888  888888 

hive> select * from zz0 full outer join zz1 on zz0.uid = zz1.uid; 
111111  111111 
222222  NULL 
NULL    333333 
NULL    444444 
888888  888888 

hive> select * from zz0 left semi join zz1 on zz0.uid = zz1.uid; 
111111  111111 
888888  888888