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 <mishra.v...@gmail.com> wrote: > 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 <mishra.v...@gmail.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 >> 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.*table_name >> *WHERE clause AND clause ...* >> *ALLOW FILTERING* *LIMIT n* >> *ORDER BY compound_key_2 ASC | DESC* >> >> * >> * >> >> *is this an issue?* >> >> * >> * >> >> *-Vivek* >> >> >> >> On Tue, Mar 5, 2013 at 5:21 PM, Vivek Mishra <mishra.v...@gmail.com>wrote: >> >>> Hi, >>> I am trying to execute a cql3 query as : >>> >>> SELECT * FROM "CompositeUser" WHERE "userId"='mevivs' ALLOW FILTERING >>> LIMIT 100 >>> >>> and 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? >>> >> >> >
