Understood! Thank you for the help. On Mon, Jun 12, 2023 at 7:15 PM Bowen Song via user < user@cassandra.apache.org> wrote:
> 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 > > -- Thanks and Regards, Dimpal
