-- ga 数据日活表CREATEEXTERNALTABLEods_ga_device_dailyPARTITIONEDBY(`date`string)ROWFORMATSERDE'mobvista.dataplatform.text.TextSerde'STOREDASTEXTFILELOCATION's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/ods_ga_device_daily'TBLPROPERTIES('schema.url'='s3://mob-emr-test/dataplatform/DataWareHouse/schema/dwh/ods_ga_device_daily/ods_ga_device_daily.avsc');