use dwh; drop table etl_3s_event_daily; create external table etl_3s_event_daily ( device_id string comment 'device id', offer_id string comment 'offer_id', event_name string comment 'event_name', event_type string comment 'event_type' )partitioned by ( dt string comment '分区字段,yyyyMMdd') stored as orc location 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/etl_3s_event_daily';