I have a table with user channels in the Apache Cassandra database. And queries responsible for getting the list of channels and getting data about the channel. One of the queries requires ALLOW FILTERING, we think that the best option is to make a duplicate of the table, only it will have a primary key ((channel_id, bucket), user_id), and then the question arose, is there something like links in Apache Cassandra, so that the database does not have to constantly write and update data in both tables. If you know a solution where this does not need to be done, then I will be very grateful for the solution

I need to query records with NULL datetime fields in a Cassandra database. Specifically, I want to select rows where the datetime field is NULL.

SyntaxException: line 1:162 mismatched input ‘AND’ expecting ‘)’ (… ((actual_severity = ‘MAJOR’) [AND]…)

SyntaxException: line 1:162 mismatched input ‘AND’ expecting ‘)’ (… ((actual_severity = ‘MAJOR’) [AND]…)