sql如下
create table tmp.Web_Rel_WebVIDUserID_All
as
(
select nextval('tmp.tmp_lvjian_seq') as EID,
e.UserID,
e.WebVID,
min(e.CalDate) as FirstDate,
max(e.CalDate) as LastDate,
min(e.FVisitTime) as FVisitTime,
max(e.LVisitTime) as LVisitTime,
Count(Distinct(e.IP)) as IPNum,
Count(Distinct(e.LogURL)) as LogUrlNum,
Count(Distinct(e.LogURL || e.LogUrlParam)) as LogUrlParamNum,
Count(Distinct(e.LogDomainNo)) as LogDomainNoNum,