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 <[email protected]> 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 <[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* >
