cassandraamazon-keyspaces

IN operator in AWS Keyspaces CQL query not working

As per the documentation, the IN operator is supported in CQL queries. However, the following query:

SELECT * FROM system_schema.tables WHERE keyspace_name IN ('system')

fails with:

Invalid WHERE Clause on table. Valid WHERE Clauses are equality clauses with keyspace_name or keyspace_name and table_name.

If I just use comparison by equality, it works fine:

SELECT * FROM system_schema.tables WHERE keyspace_name = 'system'

Am I doing something wrong, are there maybe some limitations when it comes to the IN operator that I have overseen?

Solution

  • Currently the IN operator is not supported on system tables at the time of this post. Is this query part of a third party tool or driver where you do not have the ability to change the code? If so which tool/driver?