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
Post a Comment