· 8 years ago · Aug 06, 2018, 08:32 AM
1CREATE EXTERNAL TABLE IF NOT EXISTS gandalf_staging_v5_JzLF18R.events (
2 "eventid" string,
3 "source" string,
4 "devicetype" string,
5 "validity" string,
6 "ts" string,
7 "xxxlisherdate" string,
8 "xxxlishertz" string,
9 "agencyid" string,
10 "xxxxxid" string,
11 "aaaaaaaaid" string,
12 "zzzgroupid" string,
13 "joyyy" string,
14 "expandedjoyyy" string,
15 "xxxlisher" string,
16 "lastzzzstatus" string,
17 "lastzzzstatusts" string,
18 "latencythresholdhours" string,
19 "yyy" string,
20 "yyytype" string,
21 "margin" string,
22 "xxxmargin" string,
23 "cmyyyyyy" string,
24 "cmxxxxxxx" string,
25 "cmviewxxxxxxxxxxs" string,
26 "cmzzzzzstarts" string,
27 "cmzzzzzduration" string,
28 "cmzzzzzdurationcounts" string,
29 "cmxxxxx" string,
30 "cmbotyyyyyy" string,
31 "cmduplicateyyyyyy" string,
32 "cmlatentyyyyyy" string,
33 "cmcustomconv1" string,
34 "cmcustomconv2" string,
35 "cmcustomconv3" string,
36 "xxxyyyyyy" string,
37 "xxxxxxxxxx" string,
38 "xxxviewxxxxxxxxxxs" string,
39 "xxxzzzzzstarts" string,
40 "xxxzzzzzduration" string,
41 "xxxzzzzzdurationcounts" string,
42 "xxxxxxxx" string,
43 "xxxbotyyyyyy" string,
44 "xxxduplicateyyyyyy" string,
45 "xxxlatentyyyyyy" string,
46 "xxxcustomconv1" string,
47 "xxxcustomconv2" string,
48 "xxxcustomconv3" string,
49 "zzzzzyyyyyy" string,
50 "zzzzzxxxxxxx" string,
51 "zzzzzviewxxxxxxxxxxs" string,
52 "zzzzzzzzzzstarts" string,
53 "zzzzzzzzzzduration" string,
54 "zzzzzzzzzzdurationcounts" string,
55 "zzzzzxxxxx" string,
56 "zzzzzbotyyyyyy" string,
57 "zzzzzduplicateyyyyyy" string,
58 "zzzzzlatentyyyyyy" string,
59 "zzzzzcustomconv1" string,
60 "zzzzzcustomconv2" string,
61 "zzzzzcustomconv3" string,
62 "xxxportalxxxxx" string,
63 "title" string,
64 "category" string,
65 "city" string,
66 "state" string,
67 "company" string,
68 "refnumber" string,
69 "customfields" string,
70 "clickid" string,
71 "xxxxxxxxxxtime" string,
72 "ip" string,
73 "country" string,
74 "location" string,
75 "operatingsystem" string,
76 "xxxlisherjoyyy" string,
77 "useragent" string,
78 "xxxagencyid" string,
79 "xxxxxxxxid" string,
80 "xxxaaaaaaaaid" string,
81 "xxxzzzgroupid" string,
82 "xxxjoyyy" string,
83 "xxxexpansionid" string,
84 "zzzzztoxxxlisherratio" string,
85 "markupagency" string,
86 "markupplacement" string,
87 "markupxxx" string,
88 "zzzzzxxxxxmojo" string,
89 "zzzzzxxxxxcd" string,
90 "zzzzzxxxxxselfserve" string,
91 "cmxxxxxmojo" string,
92 "cmxxxxxcd" string,
93 "cmxxxxxselfserve" string,
94 "xxxxxxxxmojo" string,
95 "xxxxxxxxcd" string,
96 "xxxxxxxxselfserve" string,
97 "xxxportalxxxxxmojo" string,
98 "xxxportalxxxxxcd" string,
99 "xxxportalxxxxxselfserve" string,
100 "xxxmarkupagency" string,
101 "xxxmarkupplacement" string,
102 "xxxmarkupxxx" string,
103 "zzzzzxxxxxxxxmojo" string,
104 "zzzzzxxxxxxxxcd" string,
105 "zzzzzxxxxxxxxselfserve" string,
106 "cmxxxxxxxxmojo" string,
107 "cmxxxxxxxxcd" string,
108 "cmxxxxxxxxselfserve" string,
109 "xxxxxxxxxxxmojo" string,
110 "xxxxxxxxxxxcd" string,
111 "xxxxxxxxxxxselfserve" string,
112 "xxxportalxxxxxxxxmojo" string,
113 "xxxportalxxxxxxxxcd" string,
114 "xxxportalxxxxxxxxselfserve" string,
115 "origevent" string,
116 "originalxxxlisher" string,
117 "ingestedts" string
118)
119ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
120WITH SERDEPROPERTIES (
121 "separatorChar" = ",",
122 "quoteChar" = "'",
123 "escapeChar" = "\"
124)
125LOCATION "s3://gandalf-hot-store-staging-v5/2018/8/6/JzLF18R"
126TBLPROPERTIES ("has_encrypted_data"="false")