Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2024 09:41 AM - edited 08-22-2024 09:47 AM
Hi @RickB ,
Which API are you using to invoke this? Parameter markers can be provided by:
Python using its pyspark.sql.SparkSession.sql() API.
Scala using its org.apache.spark.sql.SparkSession.sql() API.
Java using its org.apache.spark.sql.SparkSession.sql() API.
- SQL
Because in each one there are subtle differences how to provide arguments to unnamed parameter markers. Take a look at below documentation entry:
Parameter markers | Databricks on AWS
If you are using sql, you should have something like below (example from documentation)
> DECLARE stmtStr = 'SELECT current_timestamp() + ?, ? * ? AS square';
> EXECUTE IMMEDIATE stmtStr USING INTERVAL '3' HOURS, 15.0, 15.0;