Eric_Hxy的专栏

hive> select * from cmc_history_data limit 10; OK 001_10_7_8498766789855  10      7       0.03    2017-07-28 17:13:30 001_10_7_8498767853827  10      7       0.03    2017-07-28 16:55:46 001_10_7_8

查询每周销售记录的数量： SELECT COUNT(*),B.WEEK_BEG_DT FROM KYLIN_SALES AS A INNER JOIN KYLIN_CAL_DT AS B ON A.PART_DT=B.CAL_DT GROUP BY B.WEEK_BEG_DT ORDER BY B.WEEK_BEG_DT 查询每周的销售记录总数、价格均值、总价： SELECT C