insert into table dw_user_dstc_ip_h select remote_addr,count(1) as pvs,concat(month,day,hour) as hour from ods_weblog_detail Where datestr=’2013-09-18’ group by concat(month,day,hour),remote_addr;