Databricks Community

cotrariello · 11-14-2024

Hello team,I am experiencing an issue with insert operations on Databricks using the JDBC driver. In my SAS Viya system, the DatabricksJDBC42.jar driver version 2.6.40 is configured. I’ve noticed that, up to Databricks Runtime version 13.1, insert op...

cotrariello · 05-16-2025

Hi @JoseSoto ,did you try the param EnableNativeParameterizedQuery=0 in the connection string?

cotrariello · 11-22-2024

Dear @Walter_C , After an initial test with a moderate number of rows, we believed it to be the optimal solution.However, upon increasing the row count beyond a million, we realized the dataset is divided into chunks of unclear size. Sometimes chunks...

cotrariello · 11-18-2024

Dear @Walter_C,Thank you for your time and patience.Using the suggested parameter in the JDBC URL, the insert behavior has returned to normal, and everything works perfectly. However, I have not been able to find any references to this parameter in t...

cotrariello · 11-14-2024

Hi @Walter_C Thank you for the clarification. However, I’d like to emphasize that before version 14.1, specifically in version 13.1, insert operations were indeed performed in bulk. By "bulk operations," I mean that multiple SQL statements were execu...

Databricks Community

User Stats

User Activity

Issue with Non-Bulk Inserts Using JDBC on Databricks Runtime 14.1

Re: Issue with Non-Bulk Inserts Using JDBC on Databricks Runtime 14.1

Re: Issue with Non-Bulk Inserts Using JDBC on Databricks Runtime 14.1

Re: Issue with Non-Bulk Inserts Using JDBC on Databricks Runtime 14.1

Re: Issue with Non-Bulk Inserts Using JDBC on Databricks Runtime 14.1