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? >> > >
