SELECT username
FROM (VALUES("user1"),("user2"),("user3")) V(username)
EXCEPT
SELECT username
FROM userdetails;

In the query above, in Cassandra it doesn’t work, and I get the following error:

SyntaxException: line 2:5 no viable alternative at input ‘(‘ (SELECT usernameFROM [(]…)

I tried researching, but nothing was found for a solution in Cassandra.