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