You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Vladimir Golubev (Jira)" <ji...@apache.org> on 2024/04/22 13:28:00 UTC

[jira] [Created] (SPARK-47939) Parameterized queries fail for DESCRIBE & EXPLAIN w/ UNBOUND_SQL_PARAMETER error

Vladimir Golubev created SPARK-47939:
----------------------------------------

             Summary: Parameterized queries fail for DESCRIBE & EXPLAIN w/ UNBOUND_SQL_PARAMETER error
                 Key: SPARK-47939
                 URL: https://issues.apache.org/jira/browse/SPARK-47939
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 4.0.0
            Reporter: Vladimir Golubev


*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



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org