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?