forked from Segate-ekb/vector
-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_qerr.sql
18 lines (18 loc) · 1010 Bytes
/
create_qerr.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE TABLE <databaseName>.qerr(`DateTime` DateTime64(6,'Europe/Moscow'),
`duration` Int32,
`Level` Int32,
`Process` String,
`ProcessID` Int32,
`ProcessName` String,
`OSThread` Int32,
`ClientID` Int32,
`ApplicationName` String,
`ComputerName` String,
`ConnectID` Int32,
`SessionID` Int32,
`User` String,
`Query` String,
`Description` String,
`message` String,
`file` String) ENGINE = MergeTree() PARTITION BY toYYYYMM(DateTime)
ORDER BY (DateTime);