incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Lebresne <sylv...@datastax.com>
Subject Re: CQL query issue
Date Tue, 05 Mar 2013 14:49:10 GMT
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?
>>>
>>
>>
>

Mime
View raw message