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
56
57
58
59
60
61
62
63
64
65
66
67
68
use emr_doppler_v1;
DROP TABLE emr_doppler_v1.event_${date_str_undline};
create external table IF NOT EXISTS emr_doppler_v1.event_${date_str_undline}(
`version` smallint,
game_id int,
user_id string,
player_id string,
arrival_ts string,
install_ts string,
category string,
session_id string,
event_id string,
country_code string,
ip string,
revenue string,
facebook_id string,
googleplus_id string,
ios_id string,
android_id string,
google_aid string,
ios_idfa string,
ios_idfv string,
is_ad_tracking_limited boolean,
is_logged_gamecenter boolean,
is_logged_googleplay boolean,
value double,
attempt_num bigint,
score bigint,
session_num bigint,
session_length bigint,
gender string,
birth_year string,
progression string,
sdk_version string,
engine_version string,
os_version string,
manufacturer string,
device string,
platform string,
build string,
connection_type string,
is_jailbroken boolean,
pay_ft string,
currency string,
amount double,
cart_type string,
transaction_num bigint,
receipt_status string,
v1_os_major string,
v1_device string,
v1_platform string,
v1_gender string,
v1_sdk_version string,
v1_google_aid string,
v1_android_id string,
v2_category string,
install_publisher string,
install_site string,
install_campaign string,
install_adgroup string,
install_ad string,
install_keyword string,
severity string
)
row format delimited fields terminated by '|'
stored as orc
location 's3://mob-emr-test/dataplatform/emr/ga_rawdata/${prefix}/';