每日日报2021.9.27
完成内容:
1.编写2019 级课堂测试试卷-HIVE 数据分析
4统计机场
insert overwrite table leiyu select day_id as day_id ,sale_nbr as sale_nbr,sum(cnt) as cnt ,sum(round) as round from leilei where sale_nbr like 'C%' group by day_id,sale_nbr;
- 统计代理商1
insert overwrite table leiyu2 select day_id as day_id ,sale_nbr as sale_nbr,sum(cnt) as cnt ,sum(round) as round from leilei where sale_nbr like 'O%' group by day_id,sale_nbr;
遇到问题:
对sql语句不熟悉 导致我任务完成缓慢
目标:继续完成任务