CREATE EXTERNAL TABLE ods_gender_fb( 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_fb_gender'; CREATE EXTERNAL TABLE ods_gender_tp( 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_other_gender'; CREATE EXTERNAL TABLE ods_gender_ga( 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_ga_gender'; Row(device_id, "A", gender, tag, device_type) CREATE EXTERNAL TABLE ods_gender_dsp( 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_dsp_gender';