> 1). The "IN" operator is not working
> SELECT * FROM TestCF WHERE status IN ('Failed', 'Success')
IN is only valid for filtering on the row KEY
http://www.datastax.com/docs/1.0/references/cql/SELECT
e.g. it generates this error using cqlsh
cqlsh:dev> SELECT * FROM TestCF WHERE status IN ('Fa
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
> Hi
>
> I am using Cassandra 1.0.
