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]

This is not supported at the moment, please use JOIN instead.