Re: No query results while expecting results

Hello Carlos and Oded, Thanks to you all for your input! @Carlos, I did not try the thrift client yet. @Oded, thank you for deserializing the key. It looks exactly what to expect, once it's deserialized... I think we're onto something. I reproduced and simplified the case like this. First I create

RE: No query results while expecting results

nt_id 5 From: Carlos Alonso [mailto:i...@mrcalonso.com] Sent: Monday, November 23, 2015 9:00 PM To: user@cassandra.apache.org Subject: Re: No query results while expecting results Did you tried to observe it using cassandra-cli? (the thrift client) It shows the 'disk-layout' of the data

Re: No query results while expecting results

Did you tried to observe it using cassandra-cli? (the thrift client) It shows the 'disk-layout' of the data and may help as well. Otherwise, if you can reproduce it having a varint as the last part of the partition key (or at any other location), this may well be a bug. Carlos Alonso | Software E

Re: No query results while expecting results

Hello Carlos, On Mon, Nov 23, 2015 at 3:31 PM, Carlos Alonso wrote: > Well, this makes me wonder how varints are compared in java vs python > because the problem may be there. > > I'd suggest getting the token, to know which server contains the missing > data. Go there and convert sstables to js

Re: No query results while expecting results

Agree with Carlos. It might be the cql shell doing tricks. Please check the json. On Mon, Nov 23, 2015 at 2:31 PM, Carlos Alonso wrote: > Well, this makes me wonder how varints are compared in java vs python > because the problem may be there. > > I'd suggest getting the token, to know which ser

Re: No query results while expecting results

Well, this makes me wonder how varints are compared in java vs python because the problem may be there. I'd suggest getting the token, to know which server contains the missing data. Go there and convert sstables to json, find the record and see what's there as the tnt_id. You could also use the t

Re: No query results while expecting results

Hello Prem, On Mon, Nov 23, 2015 at 2:36 PM, Prem Yadav wrote: > Can you run the trace again for the query "select * " without any > conditions and see if you are getting results for tnt_id=5? > Of course, here are the results, with trace: cqlsh> tracing on Now traci

Re: No query results while expecting results

Can you run the trace again for the query "select * " without any conditions and see if you are getting results for tnt_id=5? On Mon, Nov 23, 2015 at 1:23 PM, Ramon Rockx wrote: > Hello Oded and Carlos, > > Many thanks for your tips. I modified the consistency level in cqlsh, but > with no suc

Re: No query results while expecting results

Hello Oded and Carlos, Many thanks for your tips. I modified the consistency level in cqlsh, but with no success: cqlsh> consistency ALL Consistency level set to ALL. cqlsh> select * from mls.te where period=62013120356 and tnt_id=5; Tracing session: ef0e6590-91e3-11e5-8c24-6783eab735d4 activi

Re: No query results while expecting results

Ok, so by default the CONSISTENCY LEVEL of CQLSH is ONE. Therefore it could be that the node you're connected to doesn't actually contain any of this data. Try improving the CL for that read and see what happens. Regards. Carlos Alonso | Software Engineer | @calonso

RE: No query results while expecting results

To: user@cassandra.apache.org Subject: No query results while expecting results Hello, On our Cassandra 1.2.15 test cluster I'm stuck with querying data on one of our Cassandra tables. This is the table: cqlsh> describe table mls.te; CREATE TABLE te ( period bigint, tnt_i

No query results while expecting results

Hello, On our Cassandra 1.2.15 test cluster I'm stuck with querying data on one of our Cassandra tables. This is the table: cqlsh> describe table mls.te; CREATE TABLE te ( period bigint, tnt_id varint, evt_id timeuuid, evt_type varint, data text, PRIMARY KEY ((period, tnt_id), evt_i