create external table dwh.ods_bigmedia_domestic_daily ( device_id string comment 'device id', device_type string comment 'device_type', platform string comment 'platform', network string comment '数据来自哪个广告平台', uuid string comment 'mtg平台的广告标识,用于和其他表串联', event_name string comment '事件名称', event_value string comment '事件值', timestamp_date string comment '数据时间', package_name string comment '广告所服务的package', genders string comment '性别', age_min string comment '年龄最小值', age_max string comment '年龄最大值' )partitioned by ( dt string comment '分区字段,yyyyMMdd' )stored as orc location 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/ods_bigmedia_domestic_daily'; CREATE EXTERNAL TABLE dwh.ods_gender_bm( device_id string comment 'gaid or idfa', tag string comment 'A', label string comment 'M OR F', business string comment '', device_type string comment 'device type' ) PARTITIONED BY ( dt string ) STORED AS orc LOCATION 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/tmp/get_bm_gender';