incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vivek Mishra <mishra.v...@gmail.com>
Subject Re: CQL query issue
Date Tue, 05 Mar 2013 12:01:12 GMT
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?
>

Mime
View raw message