sstable loader

Hi All, Can we use sstable loader for loading external flat file or csv file. If yes , kindly share the steps or manual. I need to put 40 million data into a table of around 70 columns Regards: Rahul Bhardwaj -- Follow IndiaMART.com for latest updates on this an

Re: Arbitrary nested tree hierarchy data model

I have a cluster which stores tree structures. I keep several hundred unrelated trees. The largest has about 180 million nodes, and the smallest has 1 node. The largest fanout is almost 400K. Depth is arbitrary, but in practice is probably less than 10. I am able to page through children and sib

Re: Finding nodes that own a given token/partition key

Thanks guys, think both of these answer my question. Guess I had overlooked nodetool getendpoints. Hopefully findable by future googlers now. On Thu, Mar 26, 2015 at 2:37 PM, Adam Holmberg wrote: > Dan, > > Depending on your context, many of the DataStax drivers have the token > ring exposed cli

Re: Deleted columns reappear after "repair"

Yep, good point: https://issues.apache.org/jira/browse/CASSANDRA-9045. On Thu, Mar 26, 2015 at 4:23 PM, Robert Coli wrote: > On Wed, Mar 25, 2015 at 6:53 PM, Roman Tkachenko > wrote: > >> Yup, I increased "in_memory_compaction_limit_in_mb" to 512MB so the row >> in question fits into it and ran

Re: Deleted columns reappear after "repair"

On Wed, Mar 25, 2015 at 6:53 PM, Roman Tkachenko wrote: > Yup, I increased "in_memory_compaction_limit_in_mb" to 512MB so the row in > question fits into it and ran repair on a couple of nodes owning its key. > The log entries about this particular row went away and those columns > haven't reappe

Re: upgrade from 1.0.12 to 1.1.12

On Wed, Mar 25, 2015 at 7:16 PM, Jonathan Haddad wrote: > There's no downside to running upgradesstables. I recommend always doing > it on upgrade just to be safe. For the record and just my opinion : I recommend against paying this fixed cost when you don't need to. It is basically trivial to

Re: Issue with removing a node and adding it back

On Thu, Mar 26, 2015 at 11:31 AM, Shiwen Cheng wrote: > I encountered an issue by removing and adding back a node. > You are encountering a failed/hung bootstrap, which probably has nothing to do with the node having been previously removenoded. Stop the node, wipe all the data on the node, inc

Re: Disastrous profusion of SSTables

On Thu, Mar 26, 2015 at 12:51 AM, Dave Galbraith wrote: > Hey! So I'm running Cassandra 2.1.2 and using the > SizeTieredCompactionStrategy. I'm doing about 3k writes/sec on a single > node. My read performance is terrible, all my queries just time out. So I > do nodetool cfstats: > For the recor

Re: Finding nodes that own a given token/partition key

Dan, Depending on your context, many of the DataStax drivers have the token ring exposed client-side. For example, Python: http://datastax.github.io/python-driver/api/cassandra/metadata.html#tokens-and-ring-topology Java: http://www.datastax.com/drivers/java/2.1/com/datastax/driver/core/Metadata.

Arbitrary nested tree hierarchy data model

Not sure if this is the right place to ask, but we are trying to model a user-generated tree hierarchy in which they create child objects of a root node, and can create an arbitrary number of children (and children of children, and on and on). So far we have looked at storing each tree structu

Re: Finding nodes that own a given token/partition key

Hi Dan, Have you tried using "nodetool getendpoints"? It shows you nodes that currently own the specific key. Roman On Thu, Mar 26, 2015 at 1:21 PM, Dan Kinder wrote: > Hey all, > > In certain cases it would be useful for us to find out which node(s) have > the data for a given token/partition

Re: Disastrous profusion of SSTables

It looks like it was CASSANDRA-8860, setting that cold reads to omit thing down to zero took my SSTable count from 641 to 1 and made all my queries work. Thank you!! On Thu, Mar 26, 2015 at 4:55 AM, graham sanderson wrote: > you may be seeing > > https://issues.apache.org/jira/browse/CASSANDRA-8

Finding nodes that own a given token/partition key

Hey all, In certain cases it would be useful for us to find out which node(s) have the data for a given token/partition key. The only solutions I'm aware of is to select from system.local and/or system.peers to grab the host_id and tokens, do `SELECT token(thing) FROM myks.mytable WHERE thing = '

Issue with removing a node and adding it back

Hi all, I encountered an issue by removing and adding back a node. Here is how this issue came out: (1) We have four nodes cluster running, but there was a hard disk failure on one of the node. Since we need to replace the hard disk, I chose to use *removenode *to remove the failed node. (2) few d

Re: Delayed events processing / queue (anti-)pattern

Interesting thought, that should work indeed, I'll evaluate both options and provide an update here once I have results. Best regards, Robin Verlangen *Chief Data Architect* W http://www.robinverlangen.nl E ro...@us2.nl *What is CloudPelican? * Discla

Re: Disastrous profusion of SSTables

you may be seeing https://issues.apache.org/jira/browse/CASSANDRA-8860 https://issues.apache.org/jira/browse/CASSANDRA-8635 related issues (which ends up with excessive numbers of sstab

Re: Disastrous profusion of SSTables

Are you frequently updating same rows ? What is the memtable flush size ? can you post the table create query here in please. On Thu, Mar 26, 2015 at 1:21 PM, Dave Galbraith wrote: > Hey! So I'm running Cassandra 2.1.2 and using the > SizeTieredCompactionStrategy. I'm doing about 3k writes/sec o

Disastrous profusion of SSTables

Hey! So I'm running Cassandra 2.1.2 and using the SizeTieredCompactionStrategy. I'm doing about 3k writes/sec on a single node. My read performance is terrible, all my queries just time out. So I do nodetool cfstats: Read Count: 42071 Read Latency: 67.47804242827601 ms. Write Count: 13