mds_adn_request_daily.sql

CREATE EXTERNAL TABLE mds_adn_request_daily(
  `device_id` string COMMENT 'device id, gaid or idfa',
  `device_type` string COMMENT 'device type idfa  gaid',
  `platform` string COMMENT 'platform:ios|android',
   req_time string comment '请求时间(yyyyMMdd HH:mm:ss)',
  `app_id` string COMMENT 'app_id',
  `ip` string COMMENT 'ip',
  `country` string COMMENT 'country',
  `model` string COMMENT 'model',
  `brand` string COMMENT 'brand'
)
PARTITIONED BY (
  `date` string
)
STORED AS RCFILE
LOCATION 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/mds_adn_request_daily';