Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

New Contributor

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 ?

1 REPLY 1
Highlighted

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

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