CREATE EXTERNAL TABLE etl_mpsdk_request_daily (
`device_id` string,
`android_id` string,
`appid` string,
`brand` string,
`model` string,
`package_list` string COMMENT '上报的安装包名列表',
`app_pname` string COMMENT '上报信息的app包名'
)
PARTITIONED BY (
`dt` string
)
STORED AS ORC
location 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/mp_request_daily';