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

Fix misleading error message for unresolved attributes inside INSERT action of MERGE INTO

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 3.0.0, 3.1.0, 3.2.0
    • None
    • SQL
    • None

    Description

      Per spec, INSERT assignments are resolved only against the source table in MERGE operations. However, the error message does not take this into account and prints all columns from both the source and target tables. This leads to confusing error messages.

      cannot resolve '`id`' given input columns: [t.c, s.c1, s.c2, t.id]

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. SPARK-30555 MERGE INTO insert action should only access columns from source table

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              aokolnychyi Anton Okolnychyi
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: