I need to get the data from cassandra with out case sensitive. Please help me.
+3
A:
There is no case-sensitivity concept in Cassandra. All the data is stored as byte[], so it's not even a String.
You can make a custom comparator (see the API) which transforms byte[] to String and disregards case.
The other thing to do is just get the data and transform it on the client side.
Actually, your question is quite unclear as of what is your goal, so I can't give more details.
Update: Run a one-time job that fetches all records from the db and updates them, setting to lower-case. Then continue inserting everything with lowercase.
Bozho
2010-09-06 09:20:02
Actually i have saved data in cassandra with lower case . But unfortunately, while updating the data, i forgot to change the case. So now the data is mixed up(lower+upper). now i need to retrieve all the data in lower case. Please help me
2010-09-06 09:29:13
@urssujith see updated
Bozho
2010-09-07 08:02:13