drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Nadeau <jacq...@dremio.com>
Subject Re: Drill 1.6 Cartesian or an inequality joins are not supporting ?
Date Sun, 07 Aug 2016 22:51:45 GMT
There is a developer flag that you can set to allow cartesian joins but
this is prone to massive memory usage at the moment. If you need it for
something small, you might find it useful.

SET `planner.enable_nljoin_for_scalar_only` = false;

--
Jacques Nadeau
CTO and Co-Founder, Dremio

On Fri, Aug 5, 2016 at 6:29 PM, Gautam Parai <gparai@maprtech.com> wrote:

> 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