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

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

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

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

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            doanduyhai DuyHai Doan

            Dates

              Created:
              Updated:

              Slack

                Issue deployment