Request to Cassandra with a condition on a column that is not a Primary Key works in DBeaver but doesn't work in Python

Question

My query has a WHERE on a column that is not a primary key.

SELECT * FROM table WHERE id_order IN ('2177579','2177130','2177072')

The query works fine in DBeaver, but when using the Cassandra library in Python:

from cassandra.cluster import Cluster string = '''SELECT * FROM table WHERE id_order IN ('2177579','2177130','2177072')''' session.execute(string)

I am getting an exception:

InvalidRequest: Error from server: code=2200 [Invalid query] message="IN predicates on non-primary-key columns (id_order) is not yet supported"

Any help would be highly appreciated