ClickHouse Certified Practice Questions - ClickHouse Certified Developer Exam

Access More Questions

A MergeTree table is defined with ORDER BY (tenant_id, event_date, user_id). A query filters only on user_id. What does ClickHouse do with the primary index for this query?

Uses the primary index efficiently since user_id is part of the key Cannot use the primary index at all because user_id is not the first key column Automatically reorders the index to match the query filter Performs a hash join against the index to find matching user_ids

Correct Answer:

Cannot use the primary index at all because user_id is not the first key column

Access more questions from this quiz

Continue to ClickHouse Certified Practice Questions - ClickHouse Certified Developer Exam for more practice questions and the full quiz experience.

Access More Questions