Do you see the following error "SYSTEM ERROR: This query cannot be planned
possibly due to either a cartesian join or an inequality join"? If so, then
there is an existing Jira (DRILL-2915) for the issue.
On Fri, Aug 5, 2016 at 10:12 AM, Jinfeng Ni <jinfengni99@gmail.com> wrote:
> 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 <rajukasula31@gmail.com>
> 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*
>
|