USE dwh; DROP TABLE IF EXISTS etl_bytedance_daily; CREATE EXTERNAL TABLE etl_bytedance_daily( device_id string, device_type string, platform string, package_name 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/bytedance_daily';