数据清洗3

1、导入表

load data local inpath '/home/data03.csv' overwrite into table qingxi03;

load data local inpath '/home/area03.csv' overwrite into table area03;

2、使用外连接进行合并

insert into table c select a.*,b.* from (select * from data03)a left join (select * from area03)b on (a.daima=b.dm);