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.