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';