forked from ClickHouse/ClickBench
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcreate.sql
More file actions
108 lines (108 loc) · 2.41 KB
/
Copy pathcreate.sql
File metadata and controls
108 lines (108 loc) · 2.41 KB
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
CREATE TABLE hits
(
WatchID long,
JavaEnable byte,
Title varchar,
GoodEvent byte,
EventTime timestamp,
Eventdate timestamp,
CounterID int,
ClientIP int,
RegionID int,
UserID long,
CounterClass byte,
OS short,
UserAgent short,
URL varchar,
Referer varchar,
IsRefresh byte,
RefererCategoryID short,
RefererRegionID int,
URLCategoryID short,
URLRegionID int,
ResolutionWidth short,
ResolutionHeight short,
ResolutionDepth short,
FlashMajor byte,
FlashMinor byte,
FlashMinor2 symbol,
NetMajor byte,
NetMinor byte,
UserAgentMajor short,
UserAgentMinor symbol,
CookieEnable byte,
JavascriptEnable byte,
IsMobile byte,
MobilePhone short,
MobilePhoneModel symbol,
Params symbol,
IPNetworkID int,
TraficSourceID int,
SearchEngineID short,
SearchPhrase varchar,
AdvEngineID short,
IsArtifical byte,
WindowClientWidth short,
WindowClientHeight short,
ClientTimeZone short,
ClientEventTime timestamp,
SilverlightVersion1 byte,
SilverlightVersion2 byte,
SilverlightVersion3 short,
SilverlightVersion4 byte,
PageCharset symbol,
CodeVersion short,
IsLink byte,
IsDownload byte,
IsNotBounce byte,
FUniqID long,
OriginalURL varchar,
HID int,
IsOldCounter byte,
IsEvent byte,
IsParameter byte,
DontCountHits byte,
WithHash byte,
HitColor char,
LocalEventTime timestamp,
Age byte,
Sex byte,
Income byte,
Interests short,
Robotness short,
RemoteIP int,
WindowName int,
OpenerName int,
HistoryLength short,
BrowserLanguage symbol,
BrowserCountry symbol,
SocialNetwork symbol,
SocialAction symbol,
HTTPError byte,
SendTiming int,
DNSTiming int,
ConnectTiming int,
ResponseStartTiming int,
ResponseEndTiming int,
FetchTiming int,
SocialSourceNetworkID short,
SocialSourcePage varchar,
ParamPrice long,
ParamOrderID symbol,
ParamCurrency symbol,
ParamCurrencyID short,
OpenstatServiceName symbol,
OpenstatCampaignID symbol,
OpenstatAdID varchar,
OpenstatSourceID symbol,
UTMSource symbol,
UTMMedium symbol,
UTMCampaign symbol,
UTMContent symbol,
UTMTerm symbol,
FromTag symbol,
HasGCLID byte,
RefererHash long,
URLHash long,
CLID int
) TIMESTAMP(EventTime) PARTITION BY DAY;