Hive supports Nonequi join ?

Question

As far as I know, Hive doesnt support NonEqui join. But in hive documention, they have mentioned NonEqui join is a valid join condition. Kindly refer the below screenshot and link.

I am getting below Error when I tried NonEqui Join..

FAILED: SemanticException [Error 10017]: Line 6:4 Both left and right aliases encountered in JOIN

Answer 1

Hive does not support inequality join it looks mistake in document .

SELECT a.* FROM a LEFT OUTER JOIN b ON (a.id = b.id)