1. 根据字符串分割实现一行变多行
关键字:LATERAL VIEW, explode,split
SELECT ad_time_slice_index, SUM(impression_count) FROM base_tracking_logs LATERRAL VIEW EXPLODE(SPLIT(ad_time_slices,'\\,')) adalias AS ad_time_slice_index WHERE dt='2015-08-01' AND hour='00' AND ad_time_slices='1,2,3,4,5,6' GROUP BY ad_time_slice_index;
OK
2 51
3 51
4 51
5 51
6 51
1 51