CQL: filter row with empty columns

3
votes

I have a cassandra database and a column family with columns (secondary keys) A, B, C. I need to select all rows from it, but filter rows with empty B column. Is it possible to do that using CQL? Or maybe it's possible just to select rows with empty column (in cql, secondary keys may be filtered only by exact value)?

1
nullcassandracql

1 Answers

2
votes

No, it's not currently possible. The filtering has to happen client-side.

If this is a type of query that you know you will need ahead of time, I recommend maintaining an index of the rows with no B column.