jliew1975_193867 avatar image
jliew1975_193867 asked Erick Ramirez edited

How do I model a table with query on a column with changing value?

I have a use case where 1 have a million trades book a day each having state (pre-book, book, settled) that changes over time. I have requirement to query the data by state for a UI requirement. Since the state changes I can't add it as primary key. How would one model this for cassandra. Do you model the table using other column as partition and filter out result of data that do not meet the state requested?

data modeling
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

0 Answers