average row size in a cassandra table

[Ayub M <hi...@gmail.com>]

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.

Re: average row size in a cassandra table

[Ayub M <hi...@gmail.com>]

Perfect, thank you.

On Thu, Dec 12, 2019 at 9:40 AM Raney, Michael <mj...@amazon.com.invalid>
wrote:

> 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 <hi...@gmail.com>
> *Reply-To: *"user@cassandra.apache.org" <us...@cassandra.apache.org>
> *Date: *Wednesday, December 11, 2019 at 11:17 PM
> *To: *"user@cassandra.apache.org" <us...@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.
>


-- 
Regards,
Ayub

Re: average row size in a cassandra table

["Raney, Michael" <mj...@amazon.com.INVALID>]

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 <hi...@gmail.com>
Reply-To: "user@cassandra.apache.org" <us...@cassandra.apache.org>
Date: Wednesday, December 11, 2019 at 11:17 PM
To: "user@cassandra.apache.org" <us...@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.