cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Pope <Stephen.P...@quest.com>
Subject RE: Get few rows by composite key.
Date Mon, 19 Mar 2012 13:45:01 GMT
Those are going to have to be separate queries, since the first is a slice, and the second
is a fetch.

Cheers,
Steve

From: Michael Cherkasov [mailto:michael.cherkasov@gmail.com]
Sent: Monday, March 19, 2012 9:41 AM
To: user@cassandra.apache.org
Subject: Re: Get few rows by composite key.

Also one more question:
Can someone show query that will fetch all rows match to this condition:  ( AA:(part 2>=
BB)  ) or ( key == (BB:CC) )
2012/3/19 Michael Cherkasov <michael.cherkasov@gmail.com<mailto:michael.cherkasov@gmail.com>>
Hello,
Assume that we have table like this one:

Key:        Columns names:
AA:AA     1:A 1:B 1:C 2:A 2:C
AA:BB     1:C 2:A 2:C
AA:CC     2:A 2:C
AA:DD     1:A 1:B 1:C
BB:AA     1:A 1:B 2:C
BB:BB     1:A 1:B 1:C 2:C
BB:CC     1:A  2:A 2:C
BB:DD     1:A  1:C 2:A 2:C

Is there any way to take rows with first key's part equals AA and second more or equal BB?
I'm interesting about Hector code.


Mime
View raw message