Error while compiling statement: FAILED: SemanticException line 0:undefined:-1

If anyone would know what the issue here is please ? I am running this in Hive

 select * from a left join b
 on a.id=b.id and a.date between b.start_dte and b.end_dte

Error while compiling statement: FAILED: SemanticException line 0:undefined:-1 Both left and right aliases encountered in JOIN 'end_dte'

Hive does not support non-equi joins.

Try to move a.date between b.start_dte and b.end_dte to the WHERE clause:

 select * from a left join b on a.id=b.id 
  where (a.date between b.start_dte and b.end_dte) or b.id is null

or b.id is null is to allow not joined records (left join)

Related