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

Parameterized queries fail for DESCRIBE & EXPLAIN w/ UNBOUND_SQL_PARAMETER error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.0.0
    • 4.0.0
    • SQL

    Description

      Succeeds: scala> spark.sql("select ?", Array(1)).show();

      Fails: spark.sql("describe select ?", Array(1)).show();

      Fails: spark.sql("explain select ?", Array(1)).show();

      Failures are of the form:

      org.apache.spark.sql.catalyst.ExtendedAnalysisException: [UNBOUND_SQL_PARAMETER] Found the unbound parameter: _16. Please, fix `args` and provide a mapping of the parameter to either a SQL literal or collection constructor functions such as `map()`, `array()`, `struct()`. SQLSTATE: 42P02; line 1 pos 16; 'Project [unresolvedalias(posparameter(16))] +- OneRowRelation

      Attachments

        Issue Links

          Activity

            People

              vladimir.golubev Vladimir Golubev
              vladimir.golubev Vladimir Golubev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: