CQL query issue when fetching data from Cassandra

[Roshan]

Hi

I am using Cassandra 1.0.6 version and having one column family in my
keyspace.

create column family TestCF
    with comparator = UTF8Type
    and column_metadata = [
        {column_name : userid,
        validation_class : BytesType,
        index_name : userid_idx,
        index_type : KEYS},
        {column_name : workspace,
        validation_class : BytesType,
        index_name : wp_idx,
        index_type : KEYS},
        {column_name : module,
        validation_class : BytesType,
        index_name : module_idx,
        index_type : KEYS},
        {column_name : action,
        validation_class : BytesType,
        index_name : action_idx,
        index_type : KEYS},
        {column_name : description,
        validation_class : BytesType},
        {column_name : status,
        validation_class : BytesType,
        index_name : status_idx,
        index_type : KEYS},
        {column_name : createdtime,
        validation_class : BytesType},
        {column_name : created,
        validation_class : BytesType,
        index_name : created_idx,
        index_type : KEYS},
        {column_name : logdetail,
        validation_class : BytesType}]
    and keys_cached = 10000
    and rows_cached = 1000
    and row_cache_save_period = 0
    and key_cache_save_period = 3600
    and memtable_throughput = 255
    and memtable_operations = 0.29;

1). The "IN" operator is not working
     SELECT * FROM TestCF WHERE status IN ('Failed', 'Success')
2) The "OR" operator is not fetching data.
    SELECT * FROM TestCF WHERE status='Failed' OR status='Success'
3) If I use "AND" operator, it also not sending data. Query doesn't have
issues, but result set is null.
    SELECT * FROM TestCF WHERE status='Failed' AND status='Success'
4) Is there any thing similar to "LIKE" in CQL? I want to search data based
on some part of string.

Could someone please help me to solve the above issues? Thanks.



--
View this message in context: 
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-query-issue-when-fetching-data-from-Cassandra-tp7290072p7290072.html
Sent from the cassandra-u...@incubator.apache.org mailing list archive at 
Nabble.com.