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.

LEFT OUTER JOIN ERROR IMPALA

LEFT OUTER JOIN ERROR IMPALA

New Contributor

Hello,

 

I have created a hive table and I want to query it per Impala,

 

My query :

select m.* from agg g

LEFT OUTER  JOIN g.im m 

 

im est array

 

I have this error :

 

AnalysisException: Syntax error in line 2: LEFT OUTER JOIN sms.msg.abo.imsi c ^ Encountered: LEFT Expected: IDENTIFIER CAUSED BY: Exception: Syntax error

 

 

1 REPLY 1
Highlighted

Re: LEFT OUTER JOIN ERROR IMPALA

Expert Contributor

Hi @mounirBG,

Try to use the full syntax of JION statement (join... on(..))!!

Good luck.