sstable2json doesn't work for secondary index sstable due to partitioner
mismatch
---------------------------------------------------------------------------------
Key: CASSANDRA-3738
URL: https://issues.apache.org/jira/browse/CASSANDRA-3738
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.0.6
Environment: linux
Reporter: Shotaro Kamio
sstable2json doesn't work for secondary index sstable in 1.0.6 while it worked
in version 0.8.x.
$ bin/sstable2json $DATA/data/Keyspace1/users-hc-1-Data.db
{
"1111": [["birth_year","1973",1326450301786000], ["full_name","Patrick
Rothfuss",1326450301782000]],
"1020": [["birth_year","1975",1326450301776000], ["full_name","Brandon
Sanderson",1326450301716000]]
}
$ bin/sstable2json $DATA/data/Keyspace1/users.users_birth_year_idx-hc-1-Data.db
Exception in thread "main" java.lang.RuntimeException: Cannot open
data/Keyspace1/users.users_birth_year_idx-hc-1 because partitioner does not
match org.apache.cassandra.dht.RandomPartitioner
at
org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:145)
at
org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:123)
at
org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:118)
at
org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:360)
at
org.apache.cassandra.tools.SSTableExport.export(SSTableExport.java:373)
at org.apache.cassandra.tools.SSTableExport.main(SSTableExport.java:431)
I tested with following sample data via cli:
create keyspace Keyspace1;
use Keyspace1;
create column family users with comparator=UTF8Type and
column_metadata=[{column_name: full_name, validation_class: UTF8Type},
{column_name: email, validation_class: UTF8Type},
{column_name: birth_year, validation_class: LongType, index_type: KEYS},
{column_name: state, validation_class: UTF8Type, index_type: KEYS}];
set users[1020][full_name] = 'Brandon Sanderson';
set users[1020][birth_year] = 1975;
set users[1111][full_name] = 'Patrick Rothfuss';
set users[1111][birth_year] = 1973;
get users where birth_year = 1973;
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira