Failure parsing the query using 'IN' operator

Hello, Guys.

I am getting this message error → “Failure parsing the query”, when I try to run a simple query using the “IN” operator.

The query is basically a select using the condition that the string array must to have a specific string.

SELECT *
FROM source
where string IN array;

What’s the problem with this statement? Is there a specific way to do that in the Dremio?

@Conradox “String in array” ia not a valid SQL statement, can you please send us the job profile?