Build Cloud-Native apps with Apache Cassandra

GOT QUESTIONS from the Workshop? You're in the right place! Post a question here and we'll get you answers.

Click here for Week 7 Materials and Homework.

Registrations still open!


question

jliew1975_193867 avatar image
jliew1975_193867 asked ·

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 characters needed characters left characters exceeded

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

0 Answers