Created
November 4, 2016 14:50
-
-
Save asigatchov/bc64c672dddd0729c6345a58d85f1486 to your computer and use it in GitHub Desktop.
clickhouse access log table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE access_log ( | |
event_date Date, | |
hostname String, | |
schema String, | |
domain String, | |
ip String, | |
datetime DateTime, | |
method String, | |
path String, | |
code UInt16, | |
size UInt64, | |
ref String, | |
ua String, | |
resp_time Float32 | |
) ENGINE = MergeTree(event_date, (path, event_date), 8192) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment