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
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.
5 People are following this question.