drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gautam Parai <gpa...@maprtech.com>
Subject Re: Drill 1.6 Cartesian or an inequality joins are not supporting ?
Date Sat, 06 Aug 2016 01:29:31 GMT
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*
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message