Range scans on columns using Astyanax

Question

My column family stores data in the column names and I want to perform range query on the columns using Astyanax. Can anyone suggest how to do that?

score 1 · Answer 1 · answered Apr 03 '13 at 05:13

There are lots example on range query available here

Sample one

keyspace.prepareQuery(CF_TIME_UUID)
    .getKey(rowKey)
    .withColumnRange(
        new RangeBuilder()
            .setLimit(10)
            .setStart(TimeUUIDUtils.getTimeUUID(0))
            .setEnd(TimeUUIDUtils
                .getTimeUUID(Long.MAX_VALUE >> 8))
            .build()).execute();

score 1 · Answer 2 · answered Apr 03 '13 at 06:38

1

I agree with abhi and this is exactly how Playorm has implemented it. You may see the code of columnSlice() API at https://github.com/deanhiller/playorm/blob/master/src/main/java/com/alvazan/orm/layer9z/spi/db/cassandra/CassandraSession.java

Also, if you are using Playorm for Cassandra you can just use its ColumnSlice API. The example is given at https://github.com/deanhiller/playorm/blob/master/src/test/java/com/alvazan/test/TestColumnSlice.java

answered Apr 03 '13 at 06:38

Easility

716
2
8
19

Could you please refer to the following link also: http://stackoverflow.com/questions/15744575/querying-columns-with-prefix-not-working-using-astyanax I am working on a problem described there. Thanks im advance for the help – labyrinth Apr 03 '13 at 10:03

score 0 · Answer 3 · answered Apr 03 '13 at 12:27

0

Actually, you could just use PlayOrm Query language as well if you final goal is getting the entities out.

answered Apr 03 '13 at 12:27

Dean Hiller

19,235
25
129
212

Range scans on columns using Astyanax

3 Answers3