CODEWITHSUNDEEP
cassandradatastax-python-driver
abhinit21
abhinit21

Reputation: 341

How do I get the size of a Cassandra table using the Python driver?

To archive this using Cassendra Shell :

nodetool cfstats -- <keyspace>.<tablename>

Python Package - cassendra-driver

Docs - cassendra

Upvotes: 1

Views: 802

Answers (2)

Aaron
Aaron

Reputation: 57748

Actually, if you're running on Cassandra 4.0+, you can use Virtual Tables to achieve this:

SELECT * FROM system_views.disk_usage
WHERE keyspace_name='stackoverflow' AND table_name='baseball_stats';


 keyspace_name | table_name     | mebibytes
---------------+----------------+-----------
 stackoverflow | baseball_stats |         1

(1 rows)

I wrote an article on Virtual Tables early last month, if you'd like more information:

Leveraging Virtual Tables in Apache Cassandra 4.0

Upvotes: 1

Erick Ramirez
Erick Ramirez

Reputation: 16293

The metrics in nodetool tablestats (formerly cfstats) is not exposed to the drivers so you cannot get this information via CQL.

These metrics are only exposed via JMX. Cheers!

Upvotes: 1

Related Questions