clickhouse-docs icon indicating copy to clipboard operation
clickhouse-docs copied to clipboard

Wrong primary.idx images in "A Practical Introduction to Primary Indexes in ClickHouse"

Open pamarcos opened this issue 1 year ago • 0 comments

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:

image

Notice the order of the columns: it says UserID, URL when it should say URL, UserID as Option 1: Secondary Tables image

pamarcos avatar Apr 05 '24 06:04 pamarcos