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 > >
