incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roshan <codeva...@gmail.com>
Subject CQL query issue when fetching data from Cassandra
Date Thu, 16 Feb 2012 05:58:15 GMT
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-user@incubator.apache.org mailing list archive at Nabble.com.

Mime
View raw message