举例子:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
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; NULL 111111 111111 NULL 333333 NULL 444444 888888 888888 hive> select * from zz0 full outer join zz1 on zz0.uid = zz1.uid; NULL 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 |