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';