ERROR: AnalysisException: Subqueries in OR predicates are not supported:

[#1]

Hi team,

when i am trying to run below query 

select b.proc,b.yr,b.RCNT from table2 b
WHERE length(b.PROC)=5 AND (b.ytype='1' or b.PROC IN (SELECT c.tet FROM table1 c));

getting an error like this:

ERROR: AnalysisException: Subqueries in OR predicates are not supported: 

can anyone help me in this ?

[#2]

please try the same in hive, i haven't validated from IMPALA end. 

[#3]

so yes, it is working in hive and not in impala.

We are using impala, what can we do?

[#4]

Maybe @kbanik or @ChethanYM could help? 

[#5]

@Yigal 

It is not supported in Impala, Below is the Jira for your reference it is still in open state and not Resolved.

https://issues.apache.org/jira/browse/IMPALA-5226

Regards,

Chethan YM