I'm trying to understand the usage of LOCAL_ONE on a read scenario. Will the LOCAL_ONE guarantee a read on a replica node always or it can be any node on the cluster. The documentation says it's the closest replica.
The issue I'm seeing is when I try to run a query with CL as ALL it gives me 150 records and if I try to run the same query with CL as ONE it is returning only 120 records.
At the Opscenter level we are running repairs so the cluster is up to date.
Appreciate your help!