
IZVEIDOJOT raw.local_transactions TABULU KLASTERĒ cluster_4x2 (
transaction_id String,
user_id String,
amount Float64,
created_at DateTime
) MOTORS = ReplicatedMergeTree()
PARTĪCIONĒT PĒC amount
KĀRTOT PĒC (transaction_id);
Izveidojiet tabulu raw.transactions KLASTERĒ cluster_4x2 (
transaction_id String,
user_id String,
amount Float64,
created_at DateTime
) MOTORS = Distributed('cluster_4x2', 'raw', 'local_transactions', cityHash64(user_id));