hive> select * from a;
OK
1 2
1 3
1 3
hive> select * from b;
OK
1 4
1 2
2 3
hive> select a.*, b.* from a left join b on a.`_c0`=b.`_c0` and a.`_c1`=b.`_c1`;
1 2 1 2
1 3 NULL NULL
1 3 NULL NULL
left join
最新推荐文章于 2024-10-07 16:32:55 发布