How to find the size of a column in Cassandra

[Vinay Kumar Chella]

I am running into Java heap size issues, so wanted to check what is the size of a column in cassandra. I am reading many columns into Java in memory.

Thanks for the help this

[Nate McCall]

nodetool cfstats
and look for the three"Compacted Row [min|max|mean]" attributes on
the column family.

If there is a big variance in the above numbers, you should
re-consider your data model.

Also, maybe don't try to read so many columns at once and use pagination.

[Vinay Kumar Chella]

Thanks Nate. This should give me the row size, but How should I get the column size? Does this gives Column size?

[Nate McCall]

In a system like Cassandra you don't know what you have until you have
it. The compacted thresholds will give you an idea of whether there
are some rows that are significantly larger than others, but finding
an individual row (and thus it's columns) will be difficult.

What sort of query is causing the heap size issues?

On Fri, Sep 28, 2012 at 4:04 PM, Vinay Kumar Chella