DROP TABLE IF EXISTS DWD_APL_GLB_DTL;
CREATE EXTERNAL TABLE DWD_APL_GLB_DTL (
gid string
,eventid String
,ts bigint
,event Map < String,String >
,uid String
,phoneNbr String
,sessionId String
,imei String
,mac String
,imsi String
,osName String
,osVer String
,androidId String
,resolution String
,deviceType String
,deviceId String
,uuid String
,appid String
,appVer String
,release_ch String
,promotion_ch String
,longtitude DOUBLE
,latitude DOUBLE
,carrier String
,netType String
,cid_sn String
,ip String
,province String
,city String
,district String
,dateStr String
,timeStr String
) partitioned BY (dt string) stored AS parquet;
创建dwd层表
最新推荐文章于 2024-06-15 06:34:42 发布