ods_gender_tab.sql 1.42 KB
Newer Older
wang-jinfeng committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
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';