drop table etl_adn_clever_daily;
CREATE EXTERNAL TABLE etl_adn_clever_daily(
  device_id string comment 'device id, gaid or idfa',
  device_type string comment 'device type idfa  gaid',
  platform string comment 'platform:ios|android',
  model string comment 'model',
  brand string comment 'brand',
  package_name string comment 'package name'
)
PARTITIONED BY (
  `date` string
)
row format delimited
FIELDS TERMINATED BY '\t'
STORED AS ORC
location 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/etl_adn_clever_daily/';