How to run cassandra queries with non-primary key columns in where clause faster.? -
i taking performance benchmarks consider cassandra db solution our project. have created table 28 columns couple of columns primary key. i loaded tables data around 250+ millions of records. when hit queries primary key columns in clause, results satisfactory. when parallelized queries in 5 threads, complete close 1 million queries in 2.5 minutes. however, when tried queries non-primary key columns in clause, 1000 queries took 2 hours. i knew that, not having primary key big disadvantage, still might have kind of situation down line. i tried see if can use secondary indexes, seems restricted 1 column only. i not find right example custom indexes needs index type class. if used columns in primary key, helpful @ least 5%.? is cassandra solution if expect more query situations without primary key columns in clause? i believe might have faced situation, great if 1 can share experience. is cassandra solution if expect more query situations without primary ke...