Support Questions
Find answers, ask questions, and share your expertise

How to work with Non-equi JOIN IN Hive? Example :select b.value from a left join b on a.date >=b.date

 
1 REPLY 1

Hello @Venkat!
Hm, the first that comes to my mind is to use cross join:

SELECT b.value FROM a,b WHERE a.date >= b.date

Just remember, depending on the size table this could be a risk to run since you're multiplying each line from a against b.

Hope this helps