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

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Component/s: core, jdbc-adapter
• Labels: pull-request-available
• Assignee: Michael Mior
• Reporter: Stuti Gupta
• Created: 18/Feb/19 10:04
• Updated: 03/Feb/21 09:29
• Resolved: 22/Feb/19 01:07

Description

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)

Issue Links

• 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