We had 2 node Cassandra cluster with replication factor of 1 and num_token value of 256 each. After we've added 2 more nodes to that 2 node cluster.
But after adding 2 new nodes the cluster was not balance properly. Data did not distributed to new nodes.
After i ran nodetool repair on all nodes but our keyspace not get affected because of Replication Factor as 1.
So I have changed RF to 2 and ran nodetool repair, then our keyspace got effected with repair.
But after that issue is we were not getting complete results with queries.
e.g. we had 4 months of data loaded into our tables earlier, but when we query on the tables after adding new nodes with date range we were getting data for some dates, not getting data for some dates.
Can you please help us what needs to be done for adding new nodes to the Apache Cassandra Cluster?