No reduction in disk space after delete

Hi, I configured parameter as follows - Gc_grace_seconds = 1hour. Tombstone threshold = 1% 1. I deleted 33% of the existing data but I don't see any change in disk space the next day (24 hrs). Column family had 24,000 rows and the number of partition keys per row is about 1million. Is the

RE: Smart column searching for a particular rowKey

Cannot find something corresponding to where clause there. From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com] Sent: Tuesday, February 03, 2015 2:44 PM To: user@cassandra.apache.org Subject: RE: Smart column searching for a particular rowKey Thanks, it does. How about in astyanax? From

RE: Smart column searching for a particular rowKey

b 3, 2015 at 11:28 AM, Ravi Agrawal mailto:ragra...@clearpoolgroup.com>> wrote: Hi Guys, Need help with this. My rowKey is stockName like GOOGLE, APPLE. Columns are sorted as per timestamp and they include some set of data fields like price and size. So, data would be like 1. 9:31:00, $520, 1

Smart column searching for a particular rowKey

Hi Guys, Need help with this. My rowKey is stockName like GOOGLE, APPLE. Columns are sorted as per timestamp and they include some set of data fields like price and size. So, data would be like 1. 9:31:00, $520, 100 shares 2. 9:35:09, $530, 1000 shares 3. 9:45:39, $520, 500 shares I want to searc

RE: Tombstone gc after gc grace seconds

help, C*heers, Alain 2015-01-30 1:29 GMT+01:00 Mohammed Guller mailto:moham...@glassbeam.com>>: Ravi - It may help. What version are you running? Do you know if minor compaction is getting triggered at all? One way to check would be see how many sstables the data directory has. Moha

RE: Retrieving all row keys of a CF

is trying to read 800k*200k rows. That will be 160B rows! Did you try “SELECT DISTINCT …” from cqlsh? Mohammed From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com] Sent: Thursday, January 22, 2015 11:12 PM To: user@cassandra.apache.org<mailto:user@cassandra.apache.org> Subject: RE: Retr

RE: Tombstone gc after gc grace seconds

I don't think that such a thing exists as SSTables are immutable. You compact it entirely or you don't. Minor compaction will eventually evict tombstones. If it is too slow, AFAIK, the "better" solution is a major compaction. C*heers, Alain 2015-01-23 0:00 GMT+01:00 Ravi Agrawal

RE: Retrieving all row keys of a CF

all the composite columns if you are using a composite partition key. Mohammed From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com] Sent: Thursday, January 22, 2015 1:57 PM To: user@cassandra.apache.org<mailto:user@cassandra.apache.org> Subject: RE: Retrieving all row keys of a CF

Tombstone gc after gc grace seconds

Hi, I want to trigger just tombstone compaction after gc grace seconds is completed not nodetool compact keyspace column family. Anyway I can do that? Thanks

RE: Retrieving all row keys of a CF

happening, but then reading 800,000 partitions is not a normal operation. Just as an experimentation, can you set the range timeout to 45 seconds on each node and the timeout on the Astyanax client to 50 seconds? Restart the nodes after increasing the timeout and try again. Mohamme

RE: Retrieving all row keys of a CF

4) What are the timeouts for the Astyanax client? 5) Do you see GC pressure on the C* nodes? How long does GC for new gen and old gen take? 6) Does any node crash with OOM error when you try AllRowsReader? Mohammed From: Ravi Agrawal [mailto:ragra...@clearpoolgroup.com] Sent: Fri

Re: Retrieving all row keys of a CF

Hi, I and Ruchir tried query using AllRowsReader recipe but had no luck. We are seeing PoolTimeoutException. SEVERE: [Thread_1] Error reading RowKeys com.netflix.astyanax.connectionpool.exceptions.PoolTimeoutException: PoolTimeoutException: [host=servername, latency=2003(2003), attempts=4]Timed