Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-34527

De-duplicated common columns cannot be resolved from USING/NATURAL JOIN

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 2.0.0
    • 3.2.0
    • SQL
    • None

    Description

      USING/NATURAL JOINS today have unexpectedly asymmetric behavior when resolving the duplicated common columns. For example, the left key columns can be resolved from a USING INNER JOIN, but the right key columns cannot. This is due to the Analyzer's rewrite of NATURAL/USING JOINs, which uses Project to remove the duplicated common columns.

      Attachments

        Activity

          People

            karenfeng Karen Feng
            karenfeng Karen Feng
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: