tencent_adx_tbl.sql 1.15 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


CREATE EXTERNAL TABLE dwh.ods_adn_adx_req_tmp(
   request_id string ,
   device_id string comment 'idfa',
   device_type string comment 'gaid or idfa',
   platform string comment 'android or ios',
   device_model string,
   os_version string,
   country string comment '',
   price_raw  string comment '',
   `date` string ,
)
PARTITIONED BY (
  dt string
)
STORED AS orc
LOCATION 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/ods_adn_adx_req_tmp';


CREATE EXTERNAL TABLE dwh.dim_adn_adx_package(
   package_name string
)
PARTITIONED BY (
  dt string
)
STORED AS TEXTFILE
LOCATION 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/dim_adn_adx_package';

CREATE EXTERNAL TABLE dwh.adn_adx_device_tag(
   device_id string comment 'idfa',
   device_type string comment 'gaid or idfa',
   platform string comment 'android or ios',
   device_model string,
   os_version string,
   country string comment '',
   gender string comment '',
   package_name string comment '',
   tag string,
   price  string comment '',
   `date` string
)
PARTITIONED BY (
  dt string
)
STORED AS orc
LOCATION 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/adn_adx_device_tag';