计算dwd层全局明细表

INSERT INTO TABLE DWD_APL_GLB_DTL PARTITION(dt=‘2019-10-29’)
SELECT
CASE
WHEN uid is not null and trim(uid)!=’’ THEN uid
WHEN imei is not null and trim(imei)!=’’ THEN imei
WHEN mac is not null and trim(mac)!=’’ THEN mac
WHEN imsi is not null and trim(imsi)!=’’ THEN imsi
WHEN androidId is not null and trim(androidId)!=’’ THEN androidId
WHEN uuid is not null and trim(uuid)!=’’ THEN uuid
WHEN deviceId is not null and trim(deviceId)!=’’ THEN deviceId
END AS gid,
a.eventid ,
cast(a.timestamp as bigint) as ts,
a.event ,
a.uid ,
a.phoneNbr ,
a.sessionId ,
a.imei ,
a.mac ,
a.imsi ,
a.osName ,
a.osVer ,
a.androidId ,
a.resolution ,
a.deviceType ,
a.deviceId ,
a.uuid ,
a.appid ,
a.appVer ,
a.release_ch ,
a.promotion_ch ,
a.longtitude ,
a.latitude ,
a.carrier ,
a.netType ,
a.cid_sn ,
a.ip ,
a.province ,
a.city ,
a.district ,
a.dateStr ,
a.timeStr
FROM
ODS_APP_LOG a WHERE dt=‘2019-10-29’
;