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