Running production cluster of 6 nodes with 7TB data. How do i retrieve count of a table in prod environment.
Is it ok if run Select count (*) from keyspace.tablename
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
No, it is not. I've explained the reasons in Why COUNT() is bad in Cassandra.
You will need to use a tool like the DataStax Bulk Loader (DSBulk). It is a tool for efficiently loading and unloading data from Apache Cassandra though that is not the extent of its abilities.
DSBulk has a nice feature for counting data in large tables in a distributed manner. It is open-sourced and free to use. Cheers!
5 People are following this question.
