黑广统计平台三条查询语句
20151102黑广isp
1、vod点播运营统计
selectday,dim_oem_id,count(*),count(distinct dim_user_hid) fromfact_vod_history where dim_isp_id=20151102 and day='2017-01-04' group byday,dim_oem_id;
2、vod2节目点播统计
insert overwrite local directory'/tmp/300016' row format delimited fields terminated by ','
selectday,dim_oem_id,dim_movie_mid,count(*),count(distinct dim_user_hid) fromfact_vod_history where dim_isp_id=20151102 and day='2017-01-04' group byday,dim_oem_id,dim_movie_mid;
3、vod3回看时移统计
insert overwrite local directory'/tmp/300017' row format delimited fields terminated by ','
selectday,dim_oem_id,dim_live_channel_id,count(*),count(distinct dim_user_hid)from fact_vod_history where dim_isp_id=20151102 and day='2017-01-04' group byday,dim_oem_id,dim_live_channel_id;
