[CASSANDRA-11538] Give secondary index on partition column the same treatment as static column

• Type: Improvement
• Status: Open
• Priority: Low
• Resolution: Unresolved
• Component/s: Feature/2i Index, Legacy/CQL

Environment

Cassandra 3.4

• Assignee: Unassigned
• Reporter: DuyHai Doan
• Created: 08/Apr/16 16:43
• Updated: 16/Apr/19 09:30

Description

For index on static column, in the index table we store:

• partition key = base table static column value
• clustering = base table complete partition key (as a single value)

The way we handle index on partition column is different, we store:

• partition key = base table partition column value
• clustering 1 = base table complete partition key (as a single value)
• clustering 2 ... N+1 = N clustering values of the base table

It is more consistent to give partition column index the same treatment as the one for static column