[ 
https://issues.apache.org/jira/browse/CASSANDRA-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vijay updated CASSANDRA-2710:
-----------------------------

    Attachment: 0001-2710-multiple-column-ranges-cql.patch

CQL part.

cqlsh:Keyspace1> select 0 .. 2,3 from Standard1 where key = 100;
Bad Request: line 1:16 mismatched input 'from' expecting RANGEOP
cqlsh:Keyspace1> select 0 .. 2,3 .. 0 from Standard1 where key = 100;
Bad Request: Slice finish must come after start in traversal order
cqlsh:Keyspace1> select 0 .. 2,3 .. '' from Standard1 where key = 100;
 0      | 1      | 10     | 11     | 12     | 13     | 14     | 15     | 16     
| 17     | 18     | 19     | 2      | 3      | 30     | 31     | 32     | 33    
 | 34     | 35     | 36     | 37     | 38     | 39     | 4      | 40     | 41   
  | 42     | 43     | 44     | 45     | 46     | 47     | 48     | 49     | 5   
   | 50  ...
                
> Get multiple column ranges
> --------------------------
>
>                 Key: CASSANDRA-2710
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2710
>             Project: Cassandra
>          Issue Type: Sub-task
>            Reporter: David Boxenhorn
>            Assignee: Vijay
>              Labels: compositeColumns, cql
>         Attachments: 0001-2710-multiple-column-ranges-cql.patch, 
> 0001-2710-multiple-column-ranges-thrift.patch
>
>
> I have replaced all my super column families with regular column families 
> using composite columns. I have easily been able to support all previous 
> functionality (I don't need range delete) except for one thing: getting 
> multiple super columns with a single access. For this, I would need to get 
> multiple ranges. (I can get multiple columns, or a single range, but not 
> multiple ranges.) 
> For example, I used to have
> [<superColumnName1>,<subColumnName1..N>],[<superColumnName2>,<subColumnName1..N>]
> and I could get superColumnName1, superColumnName2
> Now I have
> [<len><superColumnName1>0<len><subColumnName1>..<len><superColumnName1>0<len><subColumnNameN>],[<len><superColumnName2>0<len><subColumnName1>..<len><superColumnName2>0<len><subColumnNameN>]
> and I need to get superColumnName1..superColumnName1+, 
> superColumnName2..superColumnName2+
> to get the same functionality
> I would like the clients to support this functionality, e.g. Hector to have 
> .setRages parallel to .setColumnNames 
> and for CQL to support a syntax like 
> SELECT [FIRST N] [REVERSED] name1..nameN1, name2..nameN2... FROM ...

--
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

        

Reply via email to