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
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
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
I think it is verbose to make it readable in sstableoutput. Column names
should not have any impact of final space usage.
On Mon, Jun 12, 2023 at 6:25 PM 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
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