The following query doesn't seem to work:
select * from table_a a where id in (select id from table_a where id =2) OR a.id = 1;
ERROR: AnalysisException: Subqueries in OR predicates are not supported
The same query works if I replace OR with AND operator.
This is an un-correlated subquery. Basically does the same thing as a join, so the query engine should be able to execute this.
Is there a specific reason this is not supported or this is a known bug?