forked from Segate-ekb/vector
-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_excpcntx.sql
32 lines (32 loc) · 1.73 KB
/
create_excpcntx.sql
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
CREATE TABLE <databaseName>.excpcntx(`DateTime` DateTime64(6,'Europe/Moscow'),
`duration` Int32,
`Level` Int32,
`ClientComputerName` String,
`ServerComputerName` String,
`UserName` String,
`ConnectString` String,
`SrcName` String,
`Process` String,
`ProcessID` Int32,
`ProcessName` String,
`OSThread` Int32,
`ClientID` Int32,
`ApplicationName` String,
`ComputerName` String,
`ConnectID` Int32,
`SessionID` Int32,
`User` String,
`DBMS` String,
`DataBase` String,
`Trans` String,
`Function` String,
`callWait` String,
`first` String,
`Module` String,
`Method` String,
`Sdbl` String,
`CallID` Int32,
`Context` String,
`message` String,
`file` String) ENGINE = MergeTree() PARTITION BY toYYYYMM(DateTime)
ORDER BY (DateTime);