Somebody in group, please confirm if it is an issue or that needs rectified for select syntax.-VivekOn Tue, Mar 5, 2013 at 5:31 PM, Vivek Mishra <email@example.com> wrote:
Thank you i am able to solve this one.If i am trying as :SELECT * FROM "CompositeUser" WHERE "userId"='mevivs' LIMIT 100 ALLOW FILTERINGit 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.table_name WHERE clause AND clause ... ALLOW FILTERING LIMIT n ORDER BY compound_key_2 ASC | DESCis this an issue?
-VivekOn Tue, Mar 5, 2013 at 5:21 PM, Vivek Mishra <firstname.lastname@example.org> wrote:
Hi,I am trying to execute a cql3 query as :SELECT * FROM "CompositeUser" WHERE "userId"='mevivs' ALLOW FILTERING LIMIT 100and getting given below error:Caused by: InvalidRequestException(why:line 1:70 missing EOF at 'LIMIT')at org.apache.cassandra.thrift.Cassandra$execute_cql3_query_result.read(Cassandra.java:37849)at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)at org.apache.cassandra.thrift.Cassandra$Client.recv_execute_cql3_query(Cassandra.java:1562)at org.apache.cassandra.thrift.Cassandra$Client.execute_cql3_query(Cassandra.java:1547)Is there something incorrect in syntax?