Alternatively, you can set the following configuration to false: alter session set `planner.enable_nljoin_for_scalar_only` = false;
Cartesian joins need to be processed as a nested loop join, and by default, Drill only considers nested joins in the case where at least one side of the join is a scalar subquery. -- Zelaine On Sun, Dec 25, 2016 at 2:46 PM, Ted Dunning <[email protected]> wrote: > You can fake the limitation by adding a constant column to both tables, I > think, and then joining on the constant. > > > > On Sun, Dec 25, 2016 at 2:04 PM, [email protected] <[email protected]> > wrote: > > > > > I am trying to do a cross join to get a cartesian products. > > > > Per the error message (attached) and the JIRA ticket I see it isn't > > supported. > > https://issues.apache.org/jira/browse/DRILL-3807 > > > > I wrote the query against using dfs on csv file types. > > > > Can I execute a cross join in Apache Drill just by moving my data to a > > different file type or Storage Plugin. Such as Parquet,JSON, or RDBMS > > Plugin. > > > > Regards, > > CLN > > > > >
