Re: About Composite range queries

2012-06-01 Thread Cyril Auburtin
ok sorry I thought columns inside a row had their keys hashed also So they are just putted as raw bytes thx 2012/6/1 aaron morton aa...@thelastpickle.com If you hash 4 composite keys, let's say ('A','B','C'), ('A','D','C'), ('A','E','X'), ('A','R','X'), you have only 4 hashes or you have

Re: About Composite range queries

2012-05-31 Thread Cyril Auburtin
Thx for the answer 1 more thing, a Composite key is not hashed only once I guess? It's hashed the number of part the composite have? So this means there are twice or 3 or ... as many keys as for normal column keys, is it true? Le 31 mai 2012 02:59, aaron morton aa...@thelastpickle.com a écrit :

Re: About Composite range queries

2012-05-31 Thread aaron morton
it is hashed once. To the partitioner it's just some bytes. Other parts of the code car about it's structure. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 31/05/2012, at 7:00 PM, Cyril Auburtin wrote: Thx for the answer 1 more

Re: About Composite range queries

2012-05-31 Thread Cyril Auburtin
but sorry, I dont undertand If you hash 4 composite keys, let's say ('A','B','C'), ('A','D','C'), ('A','E','X'), ('A','R','X'), you have only 4 hashes or you have more? If it's 4, how come you are able to range query for example between start_column=('A', 'D') and end_column=('A','E') and get

Re: About Composite range queries

2012-05-31 Thread aaron morton
If you hash 4 composite keys, let's say ('A','B','C'), ('A','D','C'), ('A','E','X'), ('A','R','X'), you have only 4 hashes or you have more? Four If it's 4, how come you are able to range query for example between start_column=('A', 'D') and end_column=('A','E') and get this column

Re: About Composite range queries

2012-05-30 Thread aaron morton
Composite Columns compare each part in turn, so the values are ordered as you've shown them. However the rows are not ordered according to key value. They are ordered using the random token generated by the partitioner see http://wiki.apache.org/cassandra/FAQ#range_rp What is the real

About Composite range queries

2012-05-29 Thread Cyril Auburtin
How is it done in Cassandra to be able to range query on a composite key? key1 = (A:A:C), (A:B:C), (A:C:C), (A:D:C), (B,A,C) like get_range (key1, start_column=(A,), end_column=(A, C)); will return [ (A:B:C), (A:C:C) ] (in pycassa) I mean does the composite implementation add much overhead to