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
Are you using a load balancing policy? That sounds like you are only using
node2 as a coordinator.
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
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.