I have following table in Cassandra (CQL spec 3.3.0 ):-
Users: <a,b,c,d>, Primary key a Int, B: Map<Int,Date>
Where Users table has column names as a,b,c,d
. Now I want to select all the columns for the rows where column b is null
. I did following query:-
select from Users where b = null;
but this fails with error = "message="Invalid null value in condition"
- The answer here:- null doesn't exists clarifies the semantics of null but still its not clear how do I select the columns which are not present in a row?
- Here Nulls in Cassandra an answer claims null to be supported by latest cassandra, but looks like it doesn't work for maps.
Is there any way to solve it? Or should I select all the columns from all the rows and manually check null programmatically, which of course would be very inefficient for a large database.