cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Angilella (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-5125) Support indexes on composite column components (clustered columns)
Date Mon, 20 Oct 2014 20:46:35 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-5125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14177444#comment-14177444
] 

Denis Angilella commented on CASSANDRA-5125:
--------------------------------------------

??Lastly, I'll note that the patches only add theses news indexes for non compact tables.
We should generalize to compact tables too, but that would require a bit of generalization
that I'd rather add in a second phase.??

With 2.1 and *compact* tables it is possible to CREATE INDEX on composite primary key columns,
but queries returns no results for the tests below.
Adding this comment for now, can open a new ticket if you prefer.

{code:SQL}
CREATE TABLE users2 (
   userID uuid,
   fname text,
   zip int,
   state text,
  PRIMARY KEY ((userID, fname))
) WITH COMPACT STORAGE;

CREATE INDEX ON users2 (userID);
CREATE INDEX ON users2 (fname);

INSERT INTO users2 (userID, fname, zip, state) VALUES (b3e3bc33-b237-4b55-9337-3d41de9a5649,
'John', 10007, 'NY');

// the following queries returns 0 rows, instead of 1 expected
SELECT * FROM users2 WHERE fname='John'; 
SELECT * FROM users2 WHERE userid=b3e3bc33-b237-4b55-9337-3d41de9a5649;
SELECT * FROM users2 WHERE userid=b3e3bc33-b237-4b55-9337-3d41de9a5649 AND fname='John';

// dropping 2ndary indexes restore normal behavior
{code}

> Support indexes on composite column components (clustered columns)
> ------------------------------------------------------------------
>
>                 Key: CASSANDRA-5125
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5125
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Jonathan Ellis
>            Assignee: Sylvain Lebresne
>             Fix For: 2.0 beta 1
>
>         Attachments: 0001-Refactor-aliases-into-column_metadata.txt, 0002-Generalize-CompositeIndex-for-all-column-type.txt,
0003-Handle-new-type-of-IndexExpression.txt, 0004-Handle-partition-key-indexing.txt
>
>
> Given
> {code}
> CREATE TABLE foo (
>   a int,
>   b int,
>   c int,
>   PRIMARY KEY (a, b)
> );
> {code}
> We should support {{CREATE INDEX ON foo(b)}}.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message