'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 |
|---|
