Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-11538

Give secondary index on partition column the same treatment as static column

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              doanduyhai DuyHai Doan
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated: