6

select

year(reqtime) year

,month(reqtime) month

,to_date(reqtime) visit_date

,cast(uid as string) as user_id

,lower(app) app

,case when ptype in ('ReaderActivity','ReaderViewController') then cast(uid as string) end as read_user_id

,ext_map['origin'] origin

,ext_map['channel_id'] channel_id

,ext_map['bid'] bid

,ext_map['cidNum'] cidNum

,pubmap['currentLanguage'] currentLanguage

from dwd.dwd_clt_engn_c_pv_log

where dt>='${yes1}' and dt<='${yes2}'

and substr(dt, 1, 8)=substr(ext_map['trigger_time'], 1, 8)

and isnotnull(chid) and length(chid)>0 and length(chid)<20

and ext_map['origin'] in ('sc','nsc')

and ptype in ('ReaderActivity','ReaderViewController')

-- and vn>='1.7.5.1086'