[SPARK-45162] Unsupported map/array constructors via `call_function` in parameterized `sql()`

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 14/Sep/23 06:04
• Updated: 14/Sep/23 08:32
• Resolved: 14/Sep/23 08:32

Description

The example below demonstrates the issue:

scala> sql("SELECT element_at(:mapParam, 'a')", Map("mapParam" -> call_function("map", lit("a"), lit(1))))
org.apache.spark.sql.catalyst.ExtendedAnalysisException: [UNBOUND_SQL_PARAMETER] Found the unbound parameter: mapParam. Please, fix `args` and provide a mapping of the parameter to a SQL literal.; line 1 pos 18;
'NameParameterizedQuery [mapParam='map(a, 1)]
+- 'Project [unresolvedalias('element_at(namedparameter(mapParam), a), None)]
   +- OneRowRelation

Issue Links

• links to: GitHub Pull Request #42894