Hi, I'd appreciate it if anyone could help!
We are using offical ODBC driver (Simba Spark ODBC Driver 64-bit 2.08.02.1013) in our application. C++ APIs.
All the following SQL statements are passed through ODBC API to Databricks:
successully executing: CREATE TABLE hive_metastore.default.a_dbTab1( id DOUBLE, name STRING )
We wanted to do this: insert into hive_metastore.default.a_dbTab1(id, name) values(1, "Alice");
1. execute prepare statement successfully:
INSERT INTO hive_metastore.default.a_dbTab1(`id` , `name` ) VALUES (?,?)
2. Bind the insert statement also run successfully.
3. But when we ran the execute the insert statement, got this error:
42P02: [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while
executing query. Error message from server: org.apache.hive.service.cli.HiveSQLException:
Error running query: [UNBOUND_SQL_PARAMETER]
org.apache.spark.sql.catalyst.ExtendedAnalysisException: [UNBOUND_SQL_PARAMETER] Found
the unbound parameter: _68. Please, fix `args` and provide a mapping of the parameter to
either a SQL literal or collection constructor functions such as `map()`, `array()`,
`struct()`. SQLSTATE: 42P02; line 1 pos 68
at
org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQueryError(HiveThri
ftServerErrors.scala:49)
at
org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.$anonfun$execute$1(
SparkExecuteStatementOperation.scala:805)
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)
at com.databricks.unity.UCSEphemeralState$Handle.runWith(UCSEphemeralState.scala:51)
at com.databricks.unity.HandleImpl.runWith(UCSHandle.scala:104)
at org.apache.spark.sql.hiv
