I'm not sure about your first 2 questions. The third might be an exception:
check your Cassandra logs.
About the "like"-thing: there's no such query possibiliy in Cassandra / CQL.
You can take a look at Hadoop / Hive to tackle those problems.
2012/2/16 Roshan <codeva...@gmail.com>
> 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.
>
