数据如下:
t_sales.txt
1,nike,20180901,20180905
2,nike,20180903,20180906
3,nike,20180909,20180915
4,oppo,20180804,20180805
5,oppo,20180804,20180815
6,vivo,20180815,20180821
7,vivo,20180902,20180912
加载语句
drop table t_sales;
create table t_sales(
id int,
brand string,
startdate int,
enddate int
)
row format delimited
fields terminated by ',';
load data local inpath '/root/homework/t_sales.txt' overwrite into table t_sales;
实现如下要求:
题目:营销表数据中日期存在重复的情况,例如 id为1的enddate为 20180905,id为2的startdate为 20180903,即 id为1和 id为2的存在重复的营销日期,求出每个品牌的促销天数(重复不算)