CREATEEXTERNALTABLE`ods_dmp_user_info_v2`(`device_id`stringCOMMENT'gaid or idfa',`device_type`stringCOMMENT'gaid or idfa',`platform`stringCOMMENT'android or ios',`country`stringCOMMENT'',`age`stringCOMMENT'age range, example 0-17',`gender`stringCOMMENT'f or m or o',`tags`stringCOMMENT'tags',`package_names`stringCOMMENT'package_names',`first_req_day`stringCOMMENT'first request day [yyyy-mm-dd]',`last_req_day`stringCOMMENT'last request day [yyyy-mm-dd]')PARTITIONEDBY(`dt`string,`business`string)ROWFORMATSERDE'org.apache.hadoop.hive.ql.io.orc.OrcSerde'STOREDASINPUTFORMAT'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'OUTPUTFORMAT'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'LOCATION's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/ods_dmp_user_info_v2'