Cassandra
  1. Cassandra
  2. CASSANDRA-5125

Support indexes on composite column components (clustered columns)

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Fix Version/s: 2.0 beta 1
    • Component/s: Core
    • Labels:
      None

      Description

      Given

      CREATE TABLE foo (
        a int,
        b int,
        c int,
        PRIMARY KEY (a, b)
      );
      

      We should support CREATE INDEX ON foo(b).

      1. 0001-Refactor-aliases-into-column_metadata.txt
        108 kB
        Sylvain Lebresne
      2. 0002-Generalize-CompositeIndex-for-all-column-type.txt
        53 kB
        Sylvain Lebresne
      3. 0003-Handle-new-type-of-IndexExpression.txt
        39 kB
        Sylvain Lebresne
      4. 0004-Handle-partition-key-indexing.txt
        16 kB
        Sylvain Lebresne

        Issue Links

          Activity

          Jonathan Ellis created issue -
          Jonathan Ellis made changes -
          Field Original Value New Value
          Link This issue relates to CASSANDRA-4511 [ CASSANDRA-4511 ]
          Jonathan Ellis made changes -
          Fix Version/s 1.2.2 [ 12323924 ]
          Fix Version/s 1.2.1 [ 12322953 ]
          Sylvain Lebresne made changes -
          Fix Version/s 2.0 [ 12322954 ]
          Fix Version/s 1.2.2 [ 12323924 ]
          Gavin made changes -
          Workflow no-reopen-closed, patch-avail [ 12744799 ] patch-available, re-open possible [ 12753714 ]
          Gavin made changes -
          Workflow patch-available, re-open possible [ 12753714 ] reopen-resolved, no closed status, patch-avail, testing [ 12758617 ]
          Sylvain Lebresne made changes -
          Attachment 0001-Refactor-aliases-into-column_metadata.patch [ 12569763 ]
          Attachment 0002-Generalize-CompositeIndex-for-all-column-type.patch [ 12569764 ]
          Attachment 0003-Handle-new-type-of-IndexExpression.patch [ 12569765 ]
          Attachment 0004-Handle-partition-key-indexing.patch [ 12569766 ]
          Sylvain Lebresne made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          made changes -
          Status Patch Available [ 10002 ] Testing [ 10012 ]
          Brandon Williams made changes -
          Status Testing [ 10012 ] Open [ 1 ]
          Sylvain Lebresne made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Jonathan Ellis made changes -
          Reviewer iamaleksey
          Sylvain Lebresne made changes -
          Attachment 0001-Refactor-aliases-into-column_metadata.patch [ 12569763 ]
          Sylvain Lebresne made changes -
          Attachment 0002-Generalize-CompositeIndex-for-all-column-type.patch [ 12569764 ]
          Sylvain Lebresne made changes -
          Attachment 0003-Handle-new-type-of-IndexExpression.patch [ 12569765 ]
          Sylvain Lebresne made changes -
          Attachment 0004-Handle-partition-key-indexing.patch [ 12569766 ]
          Sylvain Lebresne made changes -
          Sylvain Lebresne made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Ryan McGuire made changes -
          Link This issue relates to CASSANDRA-5534 [ CASSANDRA-5534 ]
          Jonathan Ellis made changes -
          Summary Support indexes on composite column components Support indexes on composite column components (clustered columns)

            People

            • Assignee:
              Sylvain Lebresne
              Reporter:
              Jonathan Ellis
              Reviewer:
              Aleksey Yeschenko
            • Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development