Regarding IN ANY/SOME, NOT IN ANY/SOME, IN ALL operators as in teradata

Dremio University
1

while using these operators IN ANY/SOME, NOT IN ANY/SOME, IN ALL in dremio i am getting an error, so what can be the equivalent functions or alternatives for all those operators in dremio.

2

@Vijay1

Can you please send your query as I see the operator exists, example

SELECT ALL employees.ename
FROM localhive3.hive.employees
WHERE TRUE