创建表

CREATE EXTERNAL TABLE ODS_APP_LOG (
eventid String
,timestamp DOUBLE
,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;