etl_adn_clever_daily.sql 531 Bytes
Newer Older
wang-jinfeng committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
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/';