Details
-
Improvement
-
Status: Open
-
Low
-
Resolution: Unresolved
-
None
-
None
-
Cassandra 3.4
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