j8MfqhuB

1CREATE TABLE IF NOT EXISTS TABLE goods
2(
3    eventdate DateTime DEFAULT now(), 
4    sku UInt64, 
5    pharmacynumber UInt16, 
6    skuguid Nullable(UInt64) DEFAULT CAST(NULL, 'Nullable(UInt64)'), 
7    description Nullable(String) DEFAULT CAST(NULL, 'Nullable(String)'), 
8    producer Nullable(String) DEFAULT CAST(NULL, 'Nullable(String)'), 
9    quantity Nullable(UInt16) DEFAULT CAST(NULL, 'Nullable(UInt16)'), 
10    multiplier Nullable(UInt16) DEFAULT CAST(1, 'Nullable(UInt16)'), 
11    price Nullable(Float32) DEFAULT CAST(NULL, 'Nullable(Float32)'), 
12    ean13 Nullable(Int64) DEFAULT CAST(NULL, 'Nullable(Int64)'), 
13    expiration Nullable(Date) DEFAULT CAST(NULL, 'Nullable(Date)'), 
14    EventDate DateTime ALIAS eventdate, 
15    EVENTDATE DateTime ALIAS eventdate, 
16    event_date DateTime ALIAS eventdate, 
17    EVENT_DATE DateTime ALIAS eventdate, 
18    Sku UInt64 ALIAS sku, 
19    SKU UInt64 ALIAS sku, 
20    pharmacy_number UInt16 ALIAS pharmacynumber, 
21    PHARMACY_NUMBER UInt16 ALIAS pharmacynumber, 
22    PharmacyNumber UInt16 ALIAS pharmacynumber, 
23    SkuGuid Nullable(UInt64) ALIAS skuguid, 
24    SKUGUID Nullable(UInt64) ALIAS skuguid, 
25    sku_guid Nullable(UInt64) ALIAS skuguid, 
26    SKU_GUID Nullable(UInt64) ALIAS skuguid, 
27    Description Nullable(String) ALIAS description, 
28    DESCRIPTION Nullable(String) ALIAS description, 
29    Producer Nullable(String) ALIAS producer, 
30    PRODUCER Nullable(String) ALIAS producer, 
31    Quantity Nullable(UInt16) ALIAS quantity, 
32    QUANTITY Nullable(UInt16) ALIAS quantity, 
33    Multiplier Nullable(UInt16) ALIAS multiplier, 
34    MULTIPLIER Nullable(UInt16) ALIAS multiplier, 
35    Price Nullable(Float32) ALIAS price, 
36    PRICE Nullable(Float32) ALIAS price, 
37    EAN13 Nullable(Int64) ALIAS ean13, 
38    Expiration Nullable(Date) ALIAS expiration, 
39    EXPIRATION Nullable(Date) ALIAS expiration
40)
41ENGINE = ReplacingMergeTree(eventdate)
42PARTITION BY pharmacynumber
43ORDER BY (pharmacynumber, sku)
44SETTINGS index_granularity = 8192