drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Cartesian Product in Apache Drill
Date Sun, 25 Dec 2016 22:46:01 GMT
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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message