[ https://issues.apache.org/jira/browse/CASSANDRA-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13190922#comment-13190922 ]
Sylvain Lebresne commented on CASSANDRA-3761: --------------------------------------------- @jawahar In you 2), userid is the only key, and hence each user can only have one posted_at (which is unlikely what you want in that example). Creating an index on posted_at doesn't change that, it just make it possible to search for the users based on their unique posted_at value (in particular, the 2nd query or the 2nd example doesn't make a whole lot of sense). And in the first example, if you only specifiy 'WHERE userid = '..'' for instance, it'll return all the records for that userid. > CQL 3.0 > ------- > > Key: CASSANDRA-3761 > URL: https://issues.apache.org/jira/browse/CASSANDRA-3761 > Project: Cassandra > Issue Type: New Feature > Components: API > Reporter: Sylvain Lebresne > Labels: cql > Fix For: 1.1 > > Attachments: 0001-CQL-3.0.patch, > 0002-Add-support-for-switching-the-CQL-version.patch, > 0003-Makes-batches-atomic.patch, 0004-Thrift-gen-files.patch, cql_tests.py, > create_cf_syntaxes.txt > > > This ticket is a reformulation/generalization of CASSANDRA-2474. The core > change of CQL 3.0 is to introduce the new syntaxes that were discussed in > CASSANDRA-2474 that allow to: > # Provide a better/more native support for wide rows, using the idea of > transposed vie. > # The generalization to composite columns. > The attached text file create_cf_syntaxes.txt recall the new syntaxes > introduced. > The changes proposed above allow (and strongly suggest in some cases) a > number of other changes to the language that this ticket proposes to > explore/implement (more details coming in the comments). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira