ClickBench/presto/create.sql at 37b9d40d85177d0a3a1789ee6ab0c8a0373b02ad · ClickHouse/ClickBench · GitHub

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
111
CREATE TABLE IF NOT EXISTS hits (
    "watchid" bigint,
    "javaenable" smallint,
    "title" varchar(65535),
    "goodevent" smallint,
    "eventtime" timestamp,
    "eventdate" date,
    "counterid" int,
    "clientip" int,
    "regionid" int,
    "userid" bigint,
    "counterclass" smallint,
    "os" smallint,
    "useragent" smallint,
    "url" varchar(65535),
    "referer" varchar(65535),
    "isrefresh" smallint,
    "referercategoryid" smallint,
    "refererregionid" int,
    "urlcategoryid" smallint,
    "urlregionid" int,
    "resolutionwidth" smallint,
    "resolutionheight" smallint,
    "resolutiondepth" smallint,
    "flashmajor" smallint,
    "flashminor" smallint,
    "flashminor2" varchar(65535),
    "netmajor" smallint,
    "netminor" smallint,
    "useragentmajor" smallint,
    "useragentminor" varchar(65535),
    "cookieenable" smallint,
    "javascriptenable" smallint,
    "ismobile" smallint,
    "mobilephone" smallint,
    "mobilephonemodel" varchar(65535),
    "params" varchar(65535),
    "ipnetworkid" int,
    "traficsourceid" smallint,
    "searchengineid" smallint,
    "searchphrase" varchar(65535),
    "advengineid" smallint,
    "isartifical" smallint,
    "windowclientwidth" smallint,
    "windowclientheight" smallint,
    "clienttimezone" smallint,
    "clienteventtime" timestamp,
    "silverlightversion1" smallint,
    "silverlightversion2" smallint,
    "silverlightversion3" int,
    "silverlightversion4" smallint,
    "pagecharset" varchar(65535),
    "codeversion" int,
    "islink" smallint,
    "isdownload" smallint,
    "isnotbounce" smallint,
    "funiqid" bigint,
    "originalurl" varchar(65535),
    "hid" int,
    "isoldcounter" smallint,
    "isevent" smallint,
    "isparameter" smallint,
    "dontcounthits" smallint,
    "withhash" smallint,
    "hitcolor" varchar(65535),
    "localeventtime" timestamp,
    "age" smallint,
    "sex" smallint,
    "income" smallint,
    "interests" smallint,
    "robotness" smallint,
    "remoteip" int,
    "windowname" int,
    "openername" int,
    "historylength" smallint,
    "browserlanguage" varchar(65535),
    "browsercountry" varchar(65535),
    "socialnetwork" varchar(65535),
    "socialaction" varchar(65535),
    "httperror" smallint,
    "sendtiming" int,
    "dnstiming" int,
    "connecttiming" int,
    "responsestarttiming" int,
    "responseendtiming" int,
    "fetchtiming" int,
    "socialsourcenetworkid" smallint,
    "socialsourcepage" varchar(65535),
    "paramprice" bigint,
    "paramorderid" varchar(65535),
    "paramcurrency" varchar(65535),
    "paramcurrencyid" smallint,
    "openstatservicename" varchar(65535),
    "openstatcampaignid" varchar(65535),
    "openstatadid" varchar(65535),
    "openstatsourceid" varchar(65535),
    "utmsource" varchar(65535),
    "utmmedium" varchar(65535),
    "utmcampaign" varchar(65535),
    "utmcontent" varchar(65535),
    "utmterm" varchar(65535),
    "fromtag" varchar(65535),
    "hasgclid" smallint,
    "refererhash" bigint,
    "urlhash" bigint,
    "clid" int
)
WITH (
    format = 'PARQUET',
    external_location = 's3a://your-bucket/clickbench-parquet/hits/'
);