cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Patrik Modesto <>
Subject Proper Mutation to IntegerType column w/ secondary index
Date Wed, 25 Apr 2012 12:23:21 GMT

I see strange behaviour using CF with two secondary indexes, one
IntegerType one UTF8Type.

Using Cassanra 1.0.9 and CF:

create column family IndexTest
    with column_type=Standard
    and comparator=UTF8Type
    and default_validation_class=UTF8Type
    and key_validation_class=UTF8Type
    and column_metadata=
        column_name: col1,
        validation_class: UTF8Type,
        index_type: KEYS
        column_name: col2,
        validation_class: IntegerType,
        index_type: KEYS

There are 13 928 437 rows. Col1 and col2 are created in MapReduce job
from other columns. The MapReruce job is used for recreating the index
columns. The col1 secondary index works the col2 behaves strangely.
Sometimes it returns correct result, sometimes nothing like in
following example.

[default@rfTest3] get IndexTest where col1 =
RowKey: 3230727:8383582:
=> (column=col1, value=3230727:,
=> (column=col2, value=8383582, timestamp=1335348630332000)
RowKey: 3230727:8383583:
=> (column=col1, value=3230727:,
=> (column=col2, value=8383583, timestamp=1335348449078000)
RowKey: 3230727:8383579:
=> (column=col1, value=3230727:,
=> (column=col2, value=8383579, timestamp=1335348778577000)

3 Rows Returned.
Elapsed time: 292 msec(s).
[default@rfTest3] get IndexTest where col2 = 8383583;

0 Row Returned.
Elapsed time: 7 msec(s

The col2 value is written from MapReduce like this 'ByteBufferUtil.bytes(Id)'.

What can be the problem here?


View raw message