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 >


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

SELECT b.value FROM a,b WHERE >=

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