You could consider a sudo column like agent_type and make it a compound partition key. It will limit break your partition into smaller ones but you will have to query with agent_id and agent_type in that case.
On Tue, Feb 5, 2019 at 12:59 PM Bobbie Haynes <haynes30...@gmail.com> wrote: > Hi Everyone, > Could you please help me in modeling my table > below.I'm stuck here. My Partition key is agent_id and clustering column is > rowid. Each agent can have a minimum of 1000 rows to 10M depends on how > busy the agent .I'm facing large partition issue for my busy agents. > I'm using SizeTieredCompaction here..The table has Writes/Reads (70/30 > ratio) and have deletes also in the table by agentid. > > > CREATE TABLE IF NOT EXISTS XXX ( > agent_id UUID, > row_id BIGINT, > path TEXT, > security_attributes TEXT, > actor TEXT, > PRIMARY KEY (agent_id,row_id) > ) >
