[
https://issues.apache.org/jira/browse/SPARK-49017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Max Gekk resolved SPARK-49017.
------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Issue resolved by pull request 47501
[https://github.com/apache/spark/pull/47501]
> Insert statement fails when multiple parameters are being used
> --------------------------------------------------------------
>
> Key: SPARK-49017
> URL: https://issues.apache.org/jira/browse/SPARK-49017
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Mihailo Milosevic
> Assignee: Mihailo Milosevic
> Priority: Minor
> Labels: pull-request-available
> Fix For: 4.0.0
>
>
> {code:java}
> // Create table
> spark.sql("create table testtab (id int, name string)").show()
> // Insert into table using single param - WORKS
> spark.sql("insert into identifier(:tab) values(1, 'test1')",
> Map("tab" -> "testtab")).show()
> // Select from table using param - WORKS
> spark.sql("select * from identifier(:tab)",
> Map("tab" -> "testtab")).show()
> // Insert into table using multiple params - FAILS
> spark.sql("insert into identifier(:tab) values(2, :name)",
> Map("tab" -> "testtab", "name" -> "test2")).show() {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
