'Non-equi left joins In Hive

I am using Left Join b/w two tables and want to fetch all the records from right table whose id is greater than equal to the id of left table and all the records from left table.

i.e. if left table has id (1,2,3,4,5) and Right Tables has id (0,2,4,6) so in final table I want (2,4,6,1,3,5)

Can Someone help me to write the query,I am not able to use non-eq join in on clause its showing both left and right join found.

query:

SELECT t1.*,
       t2.*
FROM   lefttable t1
       LEFT JOIN righttable t2
              ON t2.id >= t1.id;  

Error:

Both left and right aliases encountered in JOIN.

I don't want to write this non-eq condition in where clause ,since in where clause it will behave like filter condition and will not give non-matching record from left table.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source