[SPARK-45137] Unsupported map and array constructors by `sql()` in connect clients

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: Connect
• Labels: pull-request-available
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 12/Sep/23 16:25
• Updated: 18/Sep/23 17:14
• Resolved: 18/Sep/23 17:14

Description

The code below demonstrates the issue:

spark.sql("select element_at(?, 1)", Array(array(lit(1)))).collect()

It fails with the error:

[info]   java.lang.UnsupportedOperationException: literal unresolved_function {
[info]   function_name: "array"
[info]   arguments {
[info]     literal {
[info]       integer: 1
[info]     }
[info]   }
[info] }
[info]  not supported (yet).

Issue Links

• links to: GitHub Pull Request #42931