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

Hive Non-Equi Left Join On Three Tables


Hive Non-Equi Left Join On Three Tables



Since Hive On Tez does not support Non-equi atm , what is the best way to work around on this ?

Suppose we have a SQL like this

select A.* from A

left join B on

A.key = B.key

and A.value Between B.start and B.end

left join C on

A.key_2 = C.akey

B.key_2 = C.bkey

and A.value Between C.start and C.end

Now we need to transform it to an valid Hive SQL , but it's really hard to get this SQL converted. I tried to use temp Tables but the B.key_2 = C.bkey clause is really a killer for my attempts.

Many Thanks in advance.

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