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
110 lines (110 loc) · 2.72 KB
/
Copy pathcreate.sql
File metadata and controls
110 lines (110 loc) · 2.72 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
109
110
CREATE TABLE test.hits
(
`WatchID` Int64,
`JavaEnable` Int16,
`Title` String,
`GoodEvent` Int16,
`EventTime` DateTime,
`EventDate` Date,
`CounterID` Int32,
`ClientIP` Int32,
`RegionID` Int32,
`UserID` Int64,
`CounterClass` Int16,
`OS` Int16,
`UserAgent` Int16,
`URL` String,
`Referer` String,
`IsRefresh` Int16,
`RefererCategoryID` Int16,
`RefererRegionID` Int32,
`URLCategoryID` Int16,
`URLRegionID` Int32,
`ResolutionWidth` Int16,
`ResolutionHeight` Int16,
`ResolutionDepth` Int16,
`FlashMajor` Int16,
`FlashMinor` Int16,
`FlashMinor2` String,
`NetMajor` Int16,
`NetMinor` Int16,
`UserAgentMajor` Int16,
`UserAgentMinor` String,
`CookieEnable` Int16,
`JavascriptEnable` Int16,
`IsMobile` Int16,
`MobilePhone` Int16,
`MobilePhoneModel` String,
`Params` String,
`IPNetworkID` Int32,
`TraficSourceID` Int16,
`SearchEngineID` Int16,
`SearchPhrase` String,
`AdvEngineID` Int16,
`IsArtifical` Int16,
`WindowClientWidth` Int16,
`WindowClientHeight` Int16,
`ClientTimeZone` Int16,
`ClientEventTime` DateTime,
`SilverlightVersion1` Int16,
`SilverlightVersion2` Int16,
`SilverlightVersion3` Int32,
`SilverlightVersion4` Int16,
`PageCharset` String,
`CodeVersion` Int32,
`IsLink` Int16,
`IsDownload` Int16,
`IsNotBounce` Int16,
`FUniqID` Int64,
`OriginalURL` String,
`HID` Int32,
`IsOldCounter` Int16,
`IsEvent` Int16,
`IsParameter` Int16,
`DontCountHits` Int16,
`WithHash` Int16,
`HitColor` String,
`LocalEventTime` DateTime,
`Age` Int16,
`Sex` Int16,
`Income` Int16,
`Interests` Int16,
`Robotness` Int16,
`RemoteIP` Int32,
`WindowName` Int32,
`OpenerName` Int32,
`HistoryLength` Int16,
`BrowserLanguage` String,
`BrowserCountry` String,
`SocialNetwork` String,
`SocialAction` String,
`HTTPError` Int16,
`SendTiming` Int32,
`DNSTiming` Int32,
`ConnectTiming` Int32,
`ResponseStartTiming` Int32,
`ResponseEndTiming` Int32,
`FetchTiming` Int32,
`SocialSourceNetworkID` Int16,
`SocialSourcePage` String,
`ParamPrice` Int64,
`ParamOrderID` String,
`ParamCurrency` String,
`ParamCurrencyID` Int16,
`OpenstatServiceName` String,
`OpenstatCampaignID` String,
`OpenstatAdID` String,
`OpenstatSourceID` String,
`UTMSource` String,
`UTMMedium` String,
`UTMCampaign` String,
`UTMContent` String,
`UTMTerm` String,
`FromTag` String,
`HasGCLID` Int16,
`RefererHash` Int64,
`URLHash` Int64,
`CLID` Int32
)
ENGINE = CnchMergeTree
ORDER BY (CounterID, EventDate, UserID, EventTime, WatchID);