I am new to Apache Cassandra, and I would like to know how to create a table in which I can filter rows by non-key columns.
In relational databases, I would simply create a table with an ID as a primary key, and then execute a
SELECT, filtering by non-key column entries. In Cassandra however, I can not do such a thing.
I have already read about secondary indexes in Cassandra. I know that I could add indexes to the property columnss and then execute a simple CQL
SELECT, similar to relational databases, and which yields me the desired rows, but that would be inefficient. Isn't there a better way?