ALLOW FILTERING error in implementing UPDATE query

Closing for now as “Cannot Reproduce”, we can revisit if new data comes to light.

Greetings , thanks for the report!

I’ll kick things off by mentioning that the error message you see there (“Cannot execute this query…”) is coming from the Cassandra server. The node.js driver notices the error response from Cassandra and passes the error message along to you but it isn’t doing any evaluation or processing of the error responses it’s receiving. So the real question is why your Cassandra server is returning that error.

It’s even more confusing since what you have above is actually perfectly valid CQL. It looks right given the docs, but to confirm I ran the following test against Cassandra 4.0.2 using version 4.7.2 of the node.js driver:

After running this sample program I observed the following:

I don’t see any way for the sample code above to generate the provided error message from the Cassandra server. Is it possible your application is doing other operations (maybe some other SELECT queries) which are the actual cause of the error?