Wide partitions and large number of partitions in Cassandra

Author: Sahil Ummer

Originally Sourced from: https://stackoverflow.com/questions/74371052/wide-partitions-and-large-number-of-partitions-in-cassandra

We are currently facing wide Partitions for certain customers. We have data in Gbs for those partitions. We tried data modelling and partitions always seems to be skewed. We were trying to use bucketing logic to minimise the partition size. Either large number of partitions are generated for low resource consuming users or Wide partitions are generated for high resource consumers. Large number of partitions lead to heap memory bloat while wide partitions lead to slower reads.

How can i solve a situation like this ?