Installation details
#ScyllaDB version: 5.4
#Cluster size: 6 nodes
os (RHEL/CentOS/Ubuntu/AWS AMI): CentOS
I update an item by adding attrs to make it a big row, but it do not compact to one. Could you please help me figure it out why it does not merge to one ? Large rows information see here
cqlsh> select * from system.large_rows;
keyspace_name | table_name | sstable_name | row_size | partition_key | clustering_key | compaction_time
-----------------------------------+------------------------+---------------------------------------------+----------+---------------+----------------+---------------------------------
alternator_obj_meta_general_qlj_2 | obj_meta_general_qlj_2 | me-3gop_1eb9_1sij42kpajyiqabklc-big-Data.db | 87420304 | example_obj | example_bi | 2025-03-19 18:06:46.851000+0000
alternator_obj_meta_general_qlj_2 | obj_meta_general_qlj_2 | me-3got_0oev_0m2r42kpajyiqabklc-big-Data.db | 52502825 | example_obj | example_bi | 2025-03-23 08:47:27.066000+0000
alternator_obj_meta_general_qlj_2 | obj_meta_general_qlj_2 | me-3gov_03xb_3ndxs2kpajyiqabklc-big-Data.db | 16134442 | example_obj | example_bi | 2025-03-25 01:24:53.256000+0000
(3 rows)
cqlsh>
cqlsh>
cqlsh> select * from system.large_cells;
keyspace_name | table_name | sstable_name | cell_size | partition_key | clustering_key | column_name | collection_elements | compaction_time
-----------------------------------+------------------------+---------------------------------------------+-----------+---------------+----------------+-------------+---------------------+---------------------------------
alternator_obj_meta_general_qlj_2 | obj_meta_general_qlj_2 | me-3gop_1eb9_1sij42kpajyiqabklc-big-Data.db | 87420279 | example_obj | example_bi | :attrs | 116645 | 2025-03-19 18:06:45.504000+0000
alternator_obj_meta_general_qlj_2 | obj_meta_general_qlj_2 | me-3got_0oev_0m2r42kpajyiqabklc-big-Data.db | 52502800 | example_obj | example_bi | :attrs | 70025 | 2025-03-23 08:47:24.623000+0000
alternator_obj_meta_general_qlj_2 | obj_meta_general_qlj_2 | me-3gov_03xb_3ndxs2kpajyiqabklc-big-Data.db | 16134417 | example_obj | example_bi | :attrs | 21496 | 2025-03-25 01:24:52.070000+0000
(3 rows)
cqlsh>