AFAIK, Drill does not support Cartesian join for now. For inequality
join, as long as the join condition has at least one equality
condition, plus inequality condition, Drill breaks into an equality
join and a filter, and it should work fine.
For example,
Join ( T1.C1 = T2.C2 and T1.C3 > T2.C4)
==>
Filter (T1.C3 > T3.C4)
\
Join (T1.C1 = T2.C2)
On Thu, Aug 4, 2016 at 5:57 PM, Raju Kasula <[email protected]> wrote:
> Hi Mapr team,
>
> We are using Drill 1.6 version and trying to use Cartesian or an
> inequality join in drill. But drill 1.6 is not supporting and throwing
> exception. Can i know when is it to be supported ?
>
> --
>
> *Thanks , *
>
> *Raj*
