createexternaltabledwh.ods_bigmedia_domestic_daily(device_idstringcomment'device id',device_typestringcomment'device_type',platformstringcomment'platform',networkstringcomment'数据来自哪个广告平台',uuidstringcomment'mtg平台的广告标识,用于和其他表串联',event_namestringcomment'事件名称',event_valuestringcomment'事件值',timestamp_datestringcomment'数据时间',package_namestringcomment'广告所服务的package',gendersstringcomment'性别',age_minstringcomment'年龄最小值',age_maxstringcomment'年龄最大值')partitionedby(dtstringcomment'分区字段,yyyyMMdd')storedasorclocation's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/ods_bigmedia_domestic_daily';CREATEEXTERNALTABLEdwh.ods_gender_bm(device_idstringcomment'gaid or idfa',tagstringcomment'A',labelstringcomment'M OR F',businessstringcomment'',device_typestringcomment'device type')PARTITIONEDBY(dtstring)STOREDASorcLOCATION's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/tmp/get_bm_gender';