Cassandra schema, query -


i'm designing new application, use cassandra (i'm new in cassandra). database contain 2-4 column families. problem that, have provide opportunity filter based on every column attributes. give me helpful suggestion have keep in mind during planning? data redundancy?

cassandra isn't optimized use-case. preferred way query data using primary key.

filtering arbitrary columns possible

  • using allow filtering query modifier
  • creating secondary index each column, not combined in single query
  • creating lookup tables different primary key variants based on column want filter

all of options have limitations.


Comments

Popular posts from this blog

python - TypeError: start must be a integer -

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

django - Creating multiple model instances in DRF3 -