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
