how would we datamodel an order service
where you have to query with status with can have only 5 values (Processing, making, shipped, Delivered, canceled):
select all the orders where status = 'shipped';
Remember we can have millions of orders and status will keep on changing. So how would i avoid wide partition issue here?
Should i say that cassandra is not good fit for this type of query ?