is not null or not equal clause in cassandra

Question

does cassandra java datastax driver has a support for not equal operations or at least filtering nulls?
Something like

query = QueryBuilder.select().from(table).where(field.ne(null))

Answer 1

It's not a problem of the driver. Cassandra doesn't support the "is not null" operator nor the "is not equal" operator. Have a look at supported operators. So there's no way to filter nulls either.

By the way, if you have these needs, I think you probably have a problem in your model.

Answer 2

You can try:

select * from mytable where column_which_might_contain_null >= '';

if your column_which_might_contain_null is a text column.