You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Maxim Potekhin <po...@bnl.gov> on 2011/11/17 18:20:54 UTC
A Cassandra CLI question: null vs 0 rows
Hello everyone,
I run a query on a secondary index. For some queries, I get 0 rows
returned. In other cases,
I just get a string that reads "null".
What's going on?
TIA
Maxim
Re: A Cassandra CLI question: null vs 0 rows
Posted by Sylvain Lebresne <sy...@datastax.com>.
Could you look at the cassandra log? This is probably due to an
error on the server side.
On Fri, Nov 18, 2011 at 4:20 AM, Maxim Potekhin <po...@bnl.gov> wrote:
> Should I file a ticket? I consistently see this behavior after a mass
> delete.
>
> On 11/17/2011 12:46 PM, Maxim Potekhin wrote:
>>
>> Thanks Jonathan. I get the bellow error. Don't have a clue as to what it
>> means.
>>
>>
>> null
>> java.lang.RuntimeException
>> at
>> org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:310)
>> at
>> org.apache.cassandra.cli.CliMain.processStatement(CliMain.java:217)
>> at org.apache.cassandra.cli.CliMain.main(CliMain.java:345)
>> Caused by: java.lang.RuntimeException
>> at
>> org.apache.cassandra.cli.CliClient.executeGetWithConditions(CliClient.java:814)
>> at
>> org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:208)
>> ... 2 more
>>
>>
>> On 11/17/2011 12:28 PM, Jonathan Ellis wrote:
>>>
>>> If CLI returns null it means there was an error -- run with --debug to
>>> check the exception.
>>>
>>> On Thu, Nov 17, 2011 at 11:20 AM, Maxim Potekhin<po...@bnl.gov>
>>> wrote:
>>>>
>>>> Hello everyone,
>>>>
>>>> I run a query on a secondary index. For some queries, I get 0 rows
>>>> returned.
>>>> In other cases,
>>>> I just get a string that reads "null".
>>>>
>>>> What's going on?
>>>>
>>>> TIA
>>>>
>>>> Maxim
>>>>
>>>>
>>>
>>>
>
>
Re: A Cassandra CLI question: null vs 0 rows
Posted by Maxim Potekhin <po...@bnl.gov>.
Should I file a ticket? I consistently see this behavior after a mass
delete.
On 11/17/2011 12:46 PM, Maxim Potekhin wrote:
> Thanks Jonathan. I get the bellow error. Don't have a clue as to what
> it means.
>
>
> null
> java.lang.RuntimeException
> at
> org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:310)
> at
> org.apache.cassandra.cli.CliMain.processStatement(CliMain.java:217)
> at org.apache.cassandra.cli.CliMain.main(CliMain.java:345)
> Caused by: java.lang.RuntimeException
> at
> org.apache.cassandra.cli.CliClient.executeGetWithConditions(CliClient.java:814)
> at
> org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:208)
> ... 2 more
>
>
> On 11/17/2011 12:28 PM, Jonathan Ellis wrote:
>> If CLI returns null it means there was an error -- run with --debug to
>> check the exception.
>>
>> On Thu, Nov 17, 2011 at 11:20 AM, Maxim Potekhin<po...@bnl.gov>
>> wrote:
>>> Hello everyone,
>>>
>>> I run a query on a secondary index. For some queries, I get 0 rows
>>> returned.
>>> In other cases,
>>> I just get a string that reads "null".
>>>
>>> What's going on?
>>>
>>> TIA
>>>
>>> Maxim
>>>
>>>
>>
>>
Varying number of rows coming from same query on same database
Posted by Maxim Potekhin <po...@bnl.gov>.
Hello,
I'm running the same query repeatedly. It's a secondary index query,
done from a Pycassa client. I see that when I iterate the "result" object,
I get slightly different number of entries when running the test serially.
There is no deletions in the database, and no writes, it's static for now.
Any comments will be appreciated.
Maxim
Re: A Cassandra CLI question: null vs 0 rows
Posted by Maxim Potekhin <po...@bnl.gov>.
Thanks Jonathan. I get the bellow error. Don't have a clue as to what it
means.
null
java.lang.RuntimeException
at
org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:310)
at
org.apache.cassandra.cli.CliMain.processStatement(CliMain.java:217)
at org.apache.cassandra.cli.CliMain.main(CliMain.java:345)
Caused by: java.lang.RuntimeException
at
org.apache.cassandra.cli.CliClient.executeGetWithConditions(CliClient.java:814)
at
org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:208)
... 2 more
On 11/17/2011 12:28 PM, Jonathan Ellis wrote:
> If CLI returns null it means there was an error -- run with --debug to
> check the exception.
>
> On Thu, Nov 17, 2011 at 11:20 AM, Maxim Potekhin<po...@bnl.gov> wrote:
>> Hello everyone,
>>
>> I run a query on a secondary index. For some queries, I get 0 rows returned.
>> In other cases,
>> I just get a string that reads "null".
>>
>> What's going on?
>>
>> TIA
>>
>> Maxim
>>
>>
>
>
Re: A Cassandra CLI question: null vs 0 rows
Posted by Jonathan Ellis <jb...@gmail.com>.
If CLI returns null it means there was an error -- run with --debug to
check the exception.
On Thu, Nov 17, 2011 at 11:20 AM, Maxim Potekhin <po...@bnl.gov> wrote:
> Hello everyone,
>
> I run a query on a secondary index. For some queries, I get 0 rows returned.
> In other cases,
> I just get a string that reads "null".
>
> What's going on?
>
> TIA
>
> Maxim
>
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com