unfortunately i do not have different of agents(agent_type) .. i only have agent_id which is also a UUID type.
On Tue, Feb 5, 2019 at 11:34 AM Nitan Kainth <nitankai...@gmail.com> wrote: > 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) >> ) >> >
