Hi All,
I have created KS & CF using cassandra-0.7.8 and inserted some
rows and column values(around 1000 rows). Later, I wanted to index 2
column values. So, I issued 'update column family..' command. After,
when I query based on indexed value it says "Row does not found".
After indexing 1. Issued nodetool flush 2.restarted Cassandra once.
Though it is same. But, I could see some XXX-Index.db file on cassandra
data directory.
What am I missing?
Here are CF details,
create column family ipinfo with column_type=Standard and
default_validation_class = UTF8Type and comparator=UTF8Type and
keys_cached=25000 and rows_cached=5000 and column_metadata=[
{ column_name : country, validation_class : UTF8Type},
{ column_name : ip, validation_class : LongType},
{ column_name : domain, validation_class : UTF8Type },
];
update column family ip with column_type=Standard and
default_validation_class = UTF8Type and comparator=UTF8Type and
keys_cached=25000 and rows_cached=5000 and column_metadata=[
{column_name : country, validation_class : UTF8Type },
{column_name : domain, validation_class : UTF8Type, index_type: KEYS},
{column_name : ip, validation_class : LongType, index_type: KEYS}
];
Any suggestions would be appreciated
Regards,
Thamizhannal P
