Reply
New Contributor
Posts: 1
Registered: ‎09-11-2018

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

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 ?

Cloudera Employee
Posts: 400
Registered: ‎03-23-2015

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

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