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.vivs@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.vivs@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.vivs@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?