A question to sstable2json

2016-09-07 Thread Lu, Boying
Hi, All, We use Cassandra 2.1.11 in our product and I tried its sstable2json to dump some sstable file like this: sstable2json full-path-to-sstable-file (e.g. xxx-Data.db). But I got an assert error at "assert initialized || keyspaceName.equals(SYSTEM_KS);" (Keyspace.java:97). The 'keysp

Is a blob storage cost of cassandra is the same as bigint storage cost for long variables?

2016-09-07 Thread Alexandr Porunov
Hello, I need to store a "Long" Java variable. The question is: whether the storage cost is the same both for store hex representation of "Long" variable to the blob and for store "Long" variable to the bigint? Are there any performance pros or cons? Is it OK to use blob as primary key? Sincerely

Re: Finding records that exist on Cassandra but not externally

2016-09-07 Thread Jens Rantil
Hi Chris, Without fully knowing your usecase; You can't keep track of which keys have changed in the external system somehow? Otherwise 2) sounds like the way to go to me. Cheers, Jens On Wed, Sep 7, 2016 at 9:47 AM wrote: > First off I hope this appropriate here- I couldn't decide whether thi

Re: Is it possible to replay hints after running nodetool drain?

2016-09-07 Thread jerome
Hi Romain, I see. Thanks for the feedback, it's much appreciated. Since the only way to force it is through JMX I think we'll continue to use our current method. Best, Jerome From: Romain Hardouin Sent: Monday, September 5, 2016 1:30:24 PM To: user@cassandra

Re: Read timeouts on primary key queries

2016-09-07 Thread Romain Hardouin
Is it still fast if you specify CONSISTENCY LOCAL_QUORUM in cqlsh? RomainLe Mercredi 7 septembre 2016 13h56, Joseph Tech a écrit : Thanks, Romain for the detailed explanation. We use log4j 2 and i have added the driver logging for slow/error queries, will see if it helps to provide any

Re: Read timeouts on primary key queries

2016-09-07 Thread Joseph Tech
Thanks, Romain for the detailed explanation. We use log4j 2 and i have added the driver logging for slow/error queries, will see if it helps to provide any pattern once in Prod. I tried getendpoints and getsstables for some of the timed out keys and most of them listed only 1 SSTable .There were a

Re: Incremental repairs in 3.0

2016-09-07 Thread Jean Carlo
Well I did an small test on my cluster and I didn't get the results I was expecting. I truncate a table lcs, Then I inserted one line and I used nodetool flush to have all the sstables. Using a RF 3 I ran a repair -inc directly and I observed that the value of Reaired At was equal 0. So I start t

unsubscribe

2016-09-07 Thread Mahmoud Younes
-- Best Regards Mahmoud K. Younes Disclaimer: This Electronic Mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you are not an addressee, or have received the message by error, please notify the send

unsubscribe

2016-09-07 Thread Mike Yeap

Finding records that exist on Cassandra but not externally

2016-09-07 Thread chris
First off I hope this appropriate here- I couldn't decide whether this was a question for Cassandra users or spark users so if you think it's in the wiring place feel free to redirect me. I have a system that does a load of data manipulation using spark. The output of this program is a effecti