Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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

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

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

Don't have an account?
Coming from Hortonworks? Activate your account here