Actually, I was wrong. The column names are not stored in the *-Data.db
files, but stored in the *-Statistics.db files. Cassandra only stores
one copy of the column names per SSTable data file, therefore the disk
space usage is negligible.
On 12/06/2023 14:31, Bowen Song wrote:
The SSTable compression will take care of the storage space usage,
which means users usually don't need to worry about the length of
column names, unless they are ridiculously long and hard to compress,
or if SSTable compression is turned off.
On 12/06/2023 13:55, Dimpal Gurabani wrote:
Hi all,
We have a table with 15 columns and ~1M rows. Looking at the output
of the sstabledump tool, it seems like column names are stored in the
cell for each row. Is this understanding correct or just sstabledump
showing verbose output? If yes, is it recommended to have small
column names to save on space usage?
--
Thanks and Regards,
Dimpal
