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