CREATE EXTERNAL TABLE `ods_dmp_user_info_v2`(
`device_id` string COMMENT 'gaid or idfa',
`device_type` string COMMENT 'gaid or idfa',
`platform` string COMMENT 'android or ios',
`country` string COMMENT '',
`age` string COMMENT 'age range, example 0-17',
`gender` string COMMENT 'f or m or o',
`tags` string COMMENT 'tags',
`package_names` string COMMENT 'package_names',
`first_req_day` string COMMENT 'first request day [yyyy-mm-dd]',
`last_req_day` string COMMENT 'last request day [yyyy-mm-dd]')
PARTITIONED BY (
`dt` string,
`business` string)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
'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'