Sobes.tech
Middle

VYTVOŘTE TABULKU raw.local_transactions NA KLASTERU cluster_4x2 ( transaction_id String, user_id String, amount Float64, created_at DateTime ) MOTOR = ReplicatedMergeTree() PARTICIONOVAT PODLE amount SEŘADIT PODLE (transaction_id); VYTVOŘTE TABULKU raw.transactions NA KLASTERU cluster_4x2 ( transaction_id String, user_id String, amount Float64, created_at DateTime ) MOTOR = Distributed('cluster_4x2', 'raw', 'local_transactions', cityHash64(user_id));