I'm trying to query over columns using a slice predicate. I'm a bit confused on what can be done with the predicate, and have been having very little success getting things to work as I would expect. Not sure if this is a Cassandra limitation or something to do with Pelops.
create column family raw_user_ordered_registration
with column_type = 'Standard'
and comparator = 'CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.BooleanType)'
and default_validation_class = 'UTF8Type'
and key_validation_class = 'UTF8Type'
where my composite columns are intended to represent id:creationInterval:creationTime:removed
I'd like to query for all columns, of arbitrary id component value, that fall within a particular range of creationIntervals.
Is this possible?