This is not an issue of Cassandra. In particular
http://cassandra.apache.org/doc/cql3/CQL.html#selectStmt is up to date.
It is an issue of the datastax documentation however. I'll see with them
that this gets resolved.
On Tue, Mar 5, 2013 at 3:26 PM, Vivek Mishra wrote:
> Somebody in group, ple
Somebody in group, please confirm if it is an issue or that needs rectified
for select syntax.
-Vivek
On Tue, Mar 5, 2013 at 5:31 PM, Vivek Mishra wrote:
> Thank you i am able to solve this one.
> If i am trying as :
>
> SELECT * FROM "CompositeUser" WHERE "userId"='mevivs' LIMIT 100 ALLOW
> F
Thank you i am able to solve this one.
If i am trying as :
SELECT * FROM "CompositeUser" WHERE "userId"='mevivs' LIMIT 100 ALLOW
FILTERING
it works. Somehow got confused by
http://www.datastax.com/docs/1.2/cql_cli/cql/SELECT, which states as :
SELECT select_expression
FROM *keyspace_name.*tab
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 do
#x27; 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 "L
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-
