Re: Why nodetool cleanup should be run sequentially after node joined a cluster

2018-04-10 Thread Christophe Schmitz
Hi Mikhail, Nodetool cleanup can add a fair amount of extra load (mostly IO) on your Cassandra nodes. Therefore it is recommended to run it during lower cluster usage, and one node at a time, in order to limit the impact on your cluster. There are no technical limitations that would prevent you

Why nodetool cleanup should be run sequentially after node joined a cluster

2018-04-10 Thread Mikhail Tsaplin
Hi, In https://docs.datastax.com/en/cassandra/3.0/cassandra/operations/opsAddNodeToCluster.html there is recommendation: 6) After all new nodes are running, run nodetool cleanup on each of the previously existing nodes

Re: "Group by" while limiting a clustering column with a range

2018-04-10 Thread eyeofthefrog
I've opened the following issue: https://issues.apache.org/jira/browse/CASSANDRA-14376 On 2018/04/10 23:12:31, Chris Mildebrandt wrote: > Hey all. I’m trying to use a range to limit a clustering column while at > the same time using `group by` and running into issues.

"Group by" while limiting a clustering column with a range

2018-04-10 Thread Chris Mildebrandt
Hey all. I’m trying to use a range to limit a clustering column while at the same time using `group by` and running into issues. Here’s a sample table: create table if not exists samples (name text, partition int, sample int, city text, state text, count counter, primary key ((name, partition),

Re: Shifting data to DCOS

2018-04-10 Thread Faraz Mateen
Sorry for the late reply. I was trying to figure out some other approach to it. @Kurt - My previous cluster has 3 nodes but replication factor is 2. I am not exactly sure how I would handle the tokens. Can you explain that a bit? @Michael - Actually, my DC/OS cluster has an older version than my

Re: How to restrict users to specific DC.

2018-04-10 Thread Rahul Singh
That seems to be more of a network segmentation issue. Protect the other nodes behind a firewall / security group. Each node in the different DCs would be able to talk to each other but the user client machine can only access the traffic only DC -- Rahul Singh rahul.si...@anant.us Anant

Re: Can I sort it as a result of group by?

2018-04-10 Thread onmstester onmstester
I'm using apache spark on top of cassandra for such cases Sent using Zoho Mail On Mon, 09 Apr 2018 18:00:33 +0430 DuyHai Doan doanduy...@gmail.com wrote No, sorting by column other than clustering column is not possible On Mon, Apr 9, 2018 at 11:42 AM, Eunsu Kim