USE dwh; DROP TABLE IF EXISTS joypac_sdk_daily; CREATE EXTERNAL TABLE joypac_sdk_daily( device_id string, device_type string, platform string, package_name string, bundle_id string, country string )PARTITIONED BY ( dt string ) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' LOCATION 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/joypac_daily'; ALTER TABLE dwh.etl_adn_org_request_daily_hours ADD COLUMNS (ruid String) AFTER idfv;