JJDBC Insert Performance and Unsupported Data Types

ankit_kothiya1
Databricks Partner

‎06-17-2025 03:45 AM

We are reaching out regarding two observations with the Databricks JDBC driver:

  1. We’ve noticed that each INSERT query is taking approximately 1 second to execute via the JDBC driver (please refer to the attached screenshot). This seems unusually slow for our use case. Could you help us understand the possible reasons for this performance issue? Additionally, please let us know if there are any recommended configuration changes or optimizations we might be missing.
    ankit_kothiya1_0-1750157093748.png
  2. Could you provide a list of data types that are currently not supported by the Databricks JDBC driver?
    For Array, Map and Binary data type insertion using parameterized query, we are getting below error.
    java.sql.SQLException: [Databricks][JDBCDriver](500352) Error getting the parameter data type: HIVE_PARAMETER_QUERY_DATA_TYPE_ERR_NON_SUPPORT_DATA_TYPE

We appreciate your support and look forward to your response.