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, clhubert@gmail.com <clhubert@gmail.com>
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
>
>
|