[CALCITE-2856] Emulating COMMA JOIN as CROSS JOIN for SparkSqlDialect - ASF JIRA

XML

Word

Printable

JSON

SparkSql doesn't support COMMA JOIN for the cartesian product.

Hence, emulating COMMA JOIN as CROSS JOIN for SparkSqlDialect.

ex-

select * from table1, table2; (Not supported in Spark SQL)

select * from table1 CROSS JOIN table2; (Valid Spark SQL syntax)

relates to

CALCITE-4485 JDBC adapter generates invalid SQL when one of the joins is "INNER JOIN ... ON TRUE"

links to

GitHub Pull Request #1049

Estimated:

Not Specified

Remaining:

Logged:

20m