CODEWITHSUNDEEP
databricksazure-databricksoracle-data-integratordatabricks-sqldatabricks-connect
Rajesh Kumar
Rajesh Kumar

Reputation: 59

ENC_KEY_LEN error while running the Queries Azure Databricks

I am facing below mentioned issue while running the queries on Azure Databricks using Oracle Data integrator , please help me resolve this issue.

*Caused By: java.sql.SQLException: [Databricks]DatabricksJDBCDriver ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[org.apache.hive.service.cli.HiveSQLException:Configuration ENC_KEY_LEN is not available.:48:47, org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$:hiveOperatingError:HiveThriftServerErrors.scala:65, com.databricks.sql.hive.thriftserver.thrift.ErrorPropagationThriftHandler:runSafely:ErrorPropagationThriftHandler.scala:124, com.databricks.sql.hive.thriftserver.thrift.ErrorPropagationThriftHandler:ExecuteStatement:ErrorPropagationThriftHandler.scala:73

Upvotes: 0

Views: 278

Answers (1)

Rajesh Kumar
Rajesh Kumar

Reputation: 59

There is no straight forward option to connect ODI with Azure Databricks SQL endpoint.

Found one workaround to connect ODI with Databricks using ODI sqlunload utility , which takes the inputs as query and generate a file as an output , that file can be loaded further into target DB.

Upvotes: 0

Related Questions