CREATE TABLE default.source13 ON CLUSTER `test-export`
(
event_month Int32 MATERIALIZED toInt32(toYYYYMM(toDateTime(event_time))),
id Int64,
event_time DateTime64(6),
user_id Int32,
category String,
value Float64,
payload String
)
ENGINE = ReplicatedMergeTree(
'/clickhouse/{installation}/{cluster}/tables/default/source13',
'{replica}'
)
PARTITION BY event_month
ORDER BY (event_time, id)
SETTINGS index_granularity = 8192;
CREATE TABLE from clickhouse(DataLakeCatalog) is taking longer