Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2856

Emulating COMMA JOIN as CROSS JOIN for SparkSqlDialect

    XMLWordPrintableJSON

    Details

      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)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mmior Michael Mior
                Reporter:
                stutigupta Stuti Gupta
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m