http://www.planetcassandra.org/blog/cassandra-native-secondary-index-deep-dive/
See section E Caveats which applies to your boolean use-case On Mon, Oct 31, 2016 at 2:19 PM, Oleg Krayushkin <allight...@gmail.com> wrote: > Hi, > > Is it a good approach to make a boolean column with TTL and build a > secondary index on it? > (For example, I want to get rows which need to be updated after a certain > time, but I don't want, say, to add a filed "update_date" as clustering > column or to create another table) > > In what kind of trouble it could lead me? > > Thanks in advance for any suggestions. > > -- > > Oleg Krayushkin >