Re: load distribution that I can't explain

2017-09-13 Thread kaveh minooie
I am using RoundRobin cluster = Cluster.builder()...( socket stuff, pool option stuff ... ) .withLoadBalancingPolicy( new RoundRobinPolicy() ) .addContactPoints( hosts ) .build(); On 09/13/2017 03:02 AM, kurt greaves wrote: Are you

Re: load distribution that I can't explain

2017-09-13 Thread kurt greaves
Are you using a load balancing policy? That sounds like you are only using node2 as a coordinator.​

Re: load distribution that I can't explain

2017-09-12 Thread kaveh minooie
Hi kurt, thanks for responding. I understand that that query is very resource consuming. My question was why I only see its effect on the same node? considering that I have a replication factor of 2, I was hoping to see this load evenly distributed among those 2 nodes. That query runs

Re: load distribution that I can't explain

2017-09-11 Thread kurt greaves
Your first query will effectively have to perform table scans to satisfy what you are asking. If a query requires ALLOW FILTERING to be specified, it means that Cassandra can't really optimise that query in any way and it's going to have to query a lot of data (all of it...) to satisfy the result.