java - Cassandra Data Modelling -

i'm trying out cassandra (being using elasticsearch lot) , technically new know what's best way make columns searchable. far, it's discourage not use secondary index if have lot's of unique values in columns true case.

create table report(         id int primary key,      col1 varchar,     createdat timestamp,     col2 varchar,     col3 varchar,     ... #some more columns,     col400 varchar   ) clustering order (createdat desc); 

any thought ?

i guess if you're using dse, choice use bundled solr index columns.

there's stargate-core plugin cassandra allows have lucene-based indexes stored inside c*.