Re: LeveledCompaction, streaming bulkload, and lot's of small sstables

2014-08-20 Thread Erik Forsberg
On 2014-08-18 19:52, Robert Coli wrote: > On Mon, Aug 18, 2014 at 6:21 AM, Erik Forsberg > wrote: > > Is there some configuration knob I can tune to make this happen faster? > I'm getting a bit confused by the description for min_sstable_size, > bucket_high,

答复: can not query data from cassandra

2014-08-20 Thread 鄢来琼
Is it related to MAX_HEAP_SIZE and HEAP_NEWSIZE? My system memory size is 4G,but the MAX_HEAP_SIZE and HEAP_NEWSIZE are set to 2G and 800M, respectively. Thanks and regards, GTA Data Peter.YAN E-Mail:laiqiong@gtafe.com http://www.gtafe.com/ [说明: cid:image001.

Re: 答复: can not query data from cassandra

2014-08-20 Thread Mark Reddy
Hi, It looks like you are running into a known issue: https://issues.apache.org/jira/browse/CASSANDRA-7780 and its being worked on here: https://issues.apache.org/jira/browse/CASSANDRA-7145 Mark On 20 August 2014 09:06, 鄢来琼 wrote: > Is it related to MAX_HEAP_SIZE and HEAP_NEWSIZE? > > My sy

Delete row, TombstoneOverwhelmingException and multiple datacenters

2014-08-20 Thread Modha, Digant
Hi All, We have two data centers running Cassandra 2.0.9. Using local quorum consistency, I deleted an entire row that had 52,509 records by doing delete using only the partition key.When I count number of records for that row, I get 0 in the local datacenter from where the row was dele

Re: range query times out (on 1 node, just 1 row in table)

2014-08-20 Thread Subodh Nijsure
I am running into exact same issue where >= queries on secondary indexes don't work reliably, even in single node environment (using 2.1.0-rc5) and quering from same machine where cassandra server is running. If secondary indices can't give results, when using cassandra is one supposed to create

Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
Hi All, I have a couple of simple questions. When will Cassandra 2.1 be released as GA? Will there be a datastax CQL driver available then? Will Cassandra 2.1 and Datastax CQL driver support nested selects? If not for a combination key table and detailed table (Star Schema) what is the fastest

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Robert Stupp
Am 20.08.2014 um 22:44 schrieb Tony Anecito : > When will Cassandra 2.1 be released as GA? When it's finished :) RC6 has been released yesterday - cross your fingers - this might be 2.1.0 > Will there be a datastax CQL driver available then? Both the Java and Python drivers will get a 2.1.0 re

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
Many Thanks Robert! One last question. I read on someones blog that 2.1 will be up to 50% faster than 2.0.9 and that CQL will be the fastest to use rather than thrift. Any comments/thoughts on that? Thanks, -Tony On Wednesday, August 20, 2014 3:03 PM, Robert Stupp wrote: Am 20.08.2014

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Robert Stupp
50% is the official statement. It depends on the workload and machine capabilities. But AFAIK 50% is a rough estimate. CQL over the native protocol is generally faster than Thrift. Native protocol also allows the client (e.g. the DataStax Drivers) to get informed about cluster changes (node add

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
Thanks again Rebert. I just upgraded to 2.0.9 from 1.2.5 and had to make some small changes regarding Order By and IN used together. I had to disable paging. The upgrade was easy and worked well so far and hoping if I upgrade to 2.1.x when released I do not have to do any more code changes. I

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Robert Stupp
Ooops - 1.2.5 to 2.0.9? You should have first upgraded to (at least) 1.2.9 before upgrade to 2.0.x. See http://www.datastax.com/documentation/upgrade/doc/upgrade/cassandra/upgradeC_c.html Am 20.08.2014 um 23:22 schrieb Tony Anecito : > I just upgraded to 2.0.9 from 1.2.5 and had to make some sma

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Robert Coli
On Wed, Aug 20, 2014 at 1:44 PM, Tony Anecito wrote: > When will Cassandra 2.1 be released as GA? > > Will there be a datastax CQL driver available then? > > Will Cassandra 2.1 and Datastax CQL driver support nested selects? If not > for a combination key table and detailed table (Star Schema) wh

Disk failure policy should let you run some basic commands.

2014-08-20 Thread Kevin Burton
So , right now, I have a full cassandra cluster… all my nodes are down. Fun! And I have a table, which I could just issue a truncate command to. It's just a log table so dropping the data is fine. but instead, I can't do that because my cluster is completely offline. Now, the disk failure poli

Re: Disk failure policy should let you run some basic commands.

2014-08-20 Thread Robert Coli
On Wed, Aug 20, 2014 at 3:45 PM, Kevin Burton wrote: > So , right now, I have a full cassandra cluster… all my nodes are down. > When your cluster is down, #cassandra is probably a better outlet than cassandra-user@. > And I have a table, which I could just issue a truncate command to. It's >

Re: Disk failure policy should let you run some basic commands.

2014-08-20 Thread Kevin Burton
> > >> +1, though because you can't drop the snapshots those two commands > automatically create (if the snapshot-before-DROP even works with disk > full, which it probably doesn't...) you still need access to the machines > to reclaim your disk space. > > True.. I actually disabled the snapshot f

Re: Disk failure policy should let you run some basic commands.

2014-08-20 Thread Robert Coli
On Wed, Aug 20, 2014 at 4:24 PM, Kevin Burton wrote: > >>> +1, though because you can't drop the snapshots those two commands >> automatically create (if the snapshot-before-DROP even works with disk >> full, which it probably doesn't...) you still need access to the machines >> to reclaim your d

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
Thanks for the suggestions. I am planning to wait till 2.1 is released and for one or two minor releases that is why I have been on 1.2.5. When I installed 2.0.9 I created everything via java scripts so as to avoid any issues and it does not use anything from the older one. Does Cassandra insta

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
Ok I was wondering if 2.0.9 install reuses the old tables. I am also wondering if Cassandra 2.0.9 is installed without any other Cassandra install present if the installed Cassandra will work. I always reload everything by scripts so I did that but wondering if I need to do what I mentioned abov

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Benedict Elliott Smith
The "run versions >= x.x.6" is IMO an out of date trope. Not only does 2.1 have more than twice as many engineers working full time on it, and five times the QA engineers (which is cumulative with prior QA), we are also seeing many more users in the wild running release candidates and providing val

Re: Latest 2.1 and Datastax driver questions...

2014-08-20 Thread Tony Anecito
Thanks that is really good to know and gives confidence to those of us that have hope for Cassandra. I still get comments from friends who wonder why I want to use it when Oracle is available. I tell them I am preparing for the future and willing to try and wait out for newer better releases. S