Re: Not-Equals (!=) in Where Clause

2014-10-01 Thread Sylvain Lebresne
Right, my bad, thanks Tyler for the correction. On Tue, Sep 30, 2014 at 5:44 PM, Tyler Hobbs wrote: > I think Sylvain may not have had his coffee yet. You can't use IF's in > SELECT statements, but you can in INSERT/UPDATE/DELETE: > > UPDATE foo SET a = 0 WHERE k = 0 IF b != 0; > > On Tue, Sep

Regarding Cassandra-Stress tool

2014-10-01 Thread shahab
Hi, I am trying to benchmark our custom schema in Cassandra and I managed to run it. However there are couple of setting and issues which I couldn't find any solution/explanation for. I appreciate any comments. 1- The default number of warm-up iterations in stress tool is about 5. I would like

Re: disk space issue

2014-10-01 Thread Ken Hancock
Major compaction is bad if you're using size-tiered, especially if you're already having capacity issues. Once you have one huge table, with default settings, you'll need 4x that huge table worth of storage in order for it to compact again to ever reclaim your TTL'd data. If you're running into s

cassandra stress tools

2014-10-01 Thread shahab
Hi, I am trying to benchmark our custom schema in Cassandra and I managed to run it. However there are couple of setting and issues which I couldn't find any solution/explanation for. I appreciate any comments. 1- The default number of warm-up iterations in stress tool is about 5. I would like

CASSANDRA-7649 : upgrade existing db to 2.0.10

2014-10-01 Thread Desimpel, Ignace
I deploy/distribute the Cassandra database as an embedded service allowing me to create a basic cassandra.yaml file based on the global cluster of machines (seeds, non-seeds, ports, disks, etc...). That allows me to configure and upgrade my own software and the cassandra software using the same

Re: disk space issue

2014-10-01 Thread cem
thanks for the answers! Cem On Wed, Oct 1, 2014 at 2:38 PM, Ken Hancock wrote: > *https://github.com/hancockks/cassandra-compact-cf > * > > On Tue, Sep 30, 2014 at 5:49 PM, cem wrote: > >> Hi All, >> >> I have a 7 node cluster. One node ran ou

Cassaandra & Java 8

2014-10-01 Thread Tony Anecito
Hi All, Has anyone done any performance testing of say Cassandra 2.1 using Java 8? Thanks,-Tony

Question about incremental repair

2014-10-01 Thread John Sumsion
If you only run incremental repairs, does that mean that bitrot will go undetected for already repaired sstables? If so, is there any other process that will detect bitrot for all the repaired sstables other than full repair (or an unfortunate user)? John... NOTICE: This email message is for

Re: Question about incremental repair

2014-10-01 Thread Tyler Hobbs
Compressed SSTables store a checksum for every compressed block, which is checked each time the block is decompressed. I believe there's a ticket out there to add something similar for non-compressed SSTables. We also store the sha1 hash of SSTables in its own file on disk. On Wed, Oct 1, 2014 a

Re: Question about incremental repair

2014-10-01 Thread Robert Coli
On Wed, Oct 1, 2014 at 3:11 PM, Tyler Hobbs wrote: > Compressed SSTables store a checksum for every compressed block, which is > checked each time the block is decompressed. I believe there's a ticket > out there to add something similar for non-compressed SSTables. > > We also store the sha1 ha

Re: cassandra stress tools

2014-10-01 Thread Sumod Pawgi
Not a direct answer to your post but you can also take a look at YCSB. Sent from my iPhone > On 01-Oct-2014, at 8:38 pm, shahab wrote: > > Hi, > > I am trying to benchmark our custom schema in Cassandra and I managed to run > it. However there are couple of setting and issues which I couldn't