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