cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raney, Michael" <mjra...@amazon.com.INVALID>
Subject Re: average row size in a cassandra table
Date Thu, 12 Dec 2019 14:39:41 GMT
For rough estimate, I’ve seen the following pattern.

Sudo code
Do queries by token range at random.

Select asjson * from table;

Take the length of json string of each row.

Perform average.

Cheers.

From: Ayub M <hiayub@gmail.com>
Reply-To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Date: Wednesday, December 11, 2019 at 11:17 PM
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subject: average row size in a cassandra table

How to find average row size of a table in cassandra? I am not looking for partition size
(which can be found from nodetool tablehistograms), since a partition can have many rows.
I am looking for row size.
Mime
View raw message