Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-28405

Join with USING caluse doesn't hide original tables

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.1.0
    • None
    • SQL
    • None

    Description

      The following query doesn't work in SparkSQL as t1.* and t2.* can't be used after USING caluse.

      select t1.*, t2.* from (values (1), (2)) t1(c) left join (values (1)) t2(c) using (c)

      Attachments

        Activity

          People

            Unassigned Unassigned
            petertoth Peter Toth
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: