incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thamizh <tceg...@yahoo.co.in>
Subject Secondary index update issue
Date Wed, 07 Sep 2011 13:13:29 GMT
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
Mime
View raw message