· 6 years ago · Nov 01, 2019, 04:20 AM
1CREATE TABLE IF NOT EXISTS cdr (
2 id Int64,
3 time_total UInt16,
4 time_talk UInt16,
5 time_wait UInt16,
6 callerid String,
7 source String,
8 destination String,
9 disposition String,
10 userField String,
11 direction String,
12 destinationChannel String,
13 destinationContext String,
14 uniqueid String,
15 atc String,
16 event UInt8,
17 starttime DateTime,
18 eventDate Date
19 ) engine=MergeTree(eventDate, (atc, eventDate), 8192)