CREATEEXTERNALTABLEmds_adn_request_daily(`device_id`stringCOMMENT'device id, gaid or idfa',`device_type`stringCOMMENT'device type idfa gaid',`platform`stringCOMMENT'platform:ios|android',req_timestringcomment'请求时间(yyyyMMdd HH:mm:ss)',`app_id`stringCOMMENT'app_id',`ip`stringCOMMENT'ip',`country`stringCOMMENT'country',`model`stringCOMMENT'model',`brand`stringCOMMENT'brand')PARTITIONEDBY(`date`string)STOREDASRCFILELOCATION's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/mds_adn_request_daily';