clickhouse-docs
clickhouse-docs copied to clipboard
Wrong primary.idx images in "A Practical Introduction to Primary Indexes in ClickHouse"
Describe the issue Option 2: Materialized Views and Option 3: Projections explicitly state
Effectively the implicitly created hidden table has the same row order and primary index as the secondary table that we created explicitly:
However, both have the following primary.idx image:
Notice the order of the columns: it says UserID, URL when it should say URL, UserID as Option 1: Secondary Tables