You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Imran <im...@yahoo.com> on 2017/02/15 16:02:55 UTC

Discrete events table - Partition Question

Hello everyone -

I have a modeling challenge where we are recording events about 1000 a sec in a Cassandra table. The event id is unique and is being used as a partition key with no clustering columns. I understand this is a anti pattern and will result in discrete partitions. 
The question I have is the impact of this design on the node and in particular
- heap
- system memory
- disk usage
- in memory structures (memtable/index summary/bloom filters)
- on disk (index files)
-compaction

Any feedback is greatly appreciated.

Thanks
Imran

Re: Discrete events table - Partition Question

Posted by Ahmed Eljami <ah...@gmail.com>.
​Hello,

​I don't see any impact in your case (a table without  composite key).

But it can be less flexible on your query-pattern, in this case you can't
return an event by date... for example! but if you'r sure that you will
query only by id_event, in this case, no problems.