Reply
New Contributor
Posts: 2
Registered: ‎03-22-2018

LEFT OUTER JOIN ERROR IMPALA

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

 

 

Highlighted
Expert Contributor
Posts: 83
Registered: ‎07-17-2017

Re: LEFT OUTER JOIN ERROR IMPALA

Hi @mounirBG,

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

Good luck.

Announcements