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 [email protected] mailing list archive at
Nabble.com.
