How to read cassandra data with out case sensitive

I need to get the data from cassandra with out case sensitive. Please help me.

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 (<a href="http://wiki.apache.org/cassandra/API">see the API</a>) 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.

This has been resolved if you have SOLR enabled using:
CREATE SEARCH INDEX ON tableName WITH COLUMNS *, camelCaseColumn { lowerCase : true };

An index is created that allows the select statement to use lowercase in the where clause. For more details search for LowerCaseStrField.