1、
insert overwrite table t_xiaoming_test_for_dau values("1",6,"2.7.1"),("1",3,"2.7.1"),("1",6,"2.7.2"),("2",6,"2.7.2");
insert overwrite table t_xiaoming_test_for_newUser values("1",6,"2.7.1"),("2",6,"2.7.2");
2、
select a.*,b.* from t_xiaoming_test_for_newUser a left join t_xiaoming_test_for_dau b on a.uid=b.uid;
第二张表 t_xiaoming_test_for_newUser由两条记录变成了四条记录
+--------+-------------+--------+--------+-------------+--------+--+
| 1 | 6 | 2.7.1 | 1 | 6 | 2.7.1 |
| 1 | 6 | 2.7.1 | 1 | 3 | 2.7.1 |
| 1 | 6 | 2.7.1 | 1 | 6 | 2.7.2 |
| 2 | 6 | 2.7.2 | 2 | 6 | 2.7.2 |
+--------+-------------+--------+--------+-------------+--------+--+