insert into table dw_pvs_day select count(1) as pvs,a.month as month,a.day as day from dim_time a join ods_weblog_detail b on b.dd=’18/Sep/2013’ and a.month=b.month and a.day=b.day group by a.month,a.day;