create external table etl_adn_request_other_daily ( device_id string, device_type string, platform string, package_name string ) PARTITIONED BY ( `date` string ) stored as orc location 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/etl_adn_request_other_daily';