Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started



samuel_191829 avatar image
samuel_191829 asked samuel_191829 edited

Compaction strategy for upsert


I have a question regarding compaction strategy.

Let say I have a workload where data will be inserted once, or upsert (batch of insert for a given partition) but never updated (in terms of column update).

I'm trying to figure out if the use of Size Tiered Compaction Strategy is better than Leveled Compaction Strategy.

Because Size Tiered Compaction does not group data by rows, if I want to fetch an entire partition. (it seems the rows are spread over many SSTable).

Also the partition created will not be updated or added with new column, only during the initial write (like batch), so STC may involve only a single SSTable


10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

0 Answers