USE dwh; CREATE EXTERNAL TABLE dwh.`dsp_profile_total`( device_id string, device_type string, platform string, maker string, model string, os_version string, country string, birthday string, gender string, dmp_time 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/dsp_profile_total'; alter table dwh.dmp_interest_tag add columns(ext_data string,update_date string);