I am replicating Oracle table to Cassandra and I want to reconcile Oracle table with Cassandra table. I have two options but not sure which would be the one with "least impact on C* cluster"
1. select * from cassandra_table
2. Do a cassandra join using Oracle RDD which I got by firing SQL query on oracle database.
In the end both the options are going to get full data from C* table as it will be 100% match in join. I want to use the option where we have least impact to C* cluster as this reconcilation happens on production cluster which is used by other processes.
Any suggestions would be really helpful. Thank you.