User16502773013
Databricks Employee
Databricks Employee

‎06-23-2024 07:56 PM - edited ‎06-23-2024 09:06 PM

Hello @runninsavvy ,

The following code sample can be used in such case

 

val argArray = Array(1, 2, 3)
val argMap = Map("param" -> argArray.mkString(","))

spark.sql("SELECT 1 IN (SELECT explode(split(:param, ',')))",argMap).show()

View solution in original post

0 Kudos