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
Bringing together the Apache Cassandra experts from the community and DataStax.
Want to learn? Have a question? Want to share your expertise? You are in the right place!
Not sure where to begin? Getting Started
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.