Re: CQL3 and column slices

2012-07-31 Thread Thorsten von Eicken
In the absence of streaming, how does one retrieve a large result set in CQL3? E.g., to use the same example: > CREATE TABLE bug_test (a int, b int, c int, d int, e int, f text, PRIMARY > KEY (a, b, c, d, e) ); > with some data in it: > > SELECT * FROM bug_test; > > Results: > > a | b | c | d | e |

Re: CQL3 and column slices

2012-07-24 Thread Sylvain Lebresne
The short answer is yes, we are looking into adding streaming of results to solve that problem (https://issues.apache.org/jira/browse/CASSANDRA-4415). -- Sylvain On Tue, Jul 24, 2012 at 6:51 PM, Josep Blanquer wrote: > Thank Sylvain, > > The main argument for this is pagination. Let me try to e

Re: CQL3 and column slices

2012-07-24 Thread Josep Blanquer
Thank Sylvain, The main argument for this is pagination. Let me try to explain the use cases, and compare it to RDBMS for better illustration: 1- Right now, Cassandra doesn't stream the requests, so large resultsets are a royal pain in the neck to deal with. I.e., if I have a range_slice, or eve

Re: CQL3 and column slices

2012-07-24 Thread Sylvain Lebresne
On Tue, Jul 24, 2012 at 12:09 AM, Josep Blanquer wrote: > is there some way to express that in CQL3? something logically equivalent to > > SELECT * FROM bug_test WHERE a:b:c:d:e > 1:1:1:1:2?? No, there isn't. Not currently at least. But feel free of course to open a ticket/request on https:/

CQL3 and column slices

2012-07-23 Thread Josep Blanquer
Hi, I am confused as to what is the way to specify column slices for composite type CFs using CQL3. I first thought that the way to do so was to use the very ugly and unintuitive syntax of constructing the PK prefix with equalities, except the last part of the composite type. But, now, after see