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 -

html - How can i make an element from a bottom stacking context stays in front of another higher stacking context? -

html - href attribute breaking an element -