原始数据:
1001 2022-05-01
1001 2022-05-02
1001 2022-05-04
1001 2022-05-05
1001 2022-05-08
1001 2022-05-10
1002 2022-05-01
1002 2022-05-03
1002 2022-05-05
1002 2022-05-07
1002 2022-05-09
1002 2022-05-13
1002 2022-05-14
建表语句:
create table test2(
id string,
dt string)
row format delimited fields terminated by '\t';
插入数据:
load da