防伪网站怎么做_个体工商注册核名查询系统_无锡精美网站制作_网络cms是什么意思

drop table dw_access_info_htip;

create table dw_access_info_htip(remote_addr string, firt_req_time string, last_req_time string, stay_long string,acc_counts string)

partitioned by(prtflag_day string);

insert into table dw_access_info_htip partition(prtflag_day='18/Sep/2013')

select b.remote_addr,b.firt_req_time,b.last_req_time,b.stay_long,a.acc_counts from

(select remote_addr,count(remote_addr) as acc_counts from dw_access_info where prtflag_day='18/Sep/2013' group by remote_addr having acc_counts>1) a

join

dw_access_info b

on a.remote_addr = b.remote_addr;