insert into table dw_pvs_hour partition(datestr=’2016-03-18’) select a.month as month,a.day as day,a.hour as hour,count(1) as pvs from ods_weblog_detail a where a.datestr=’2016-03-18’ group by a.month,a.day,a.hour;