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.