Databricks Community

Quan · 06-28-2023

Having a great time at the Data & AI summit, especially enjoyed hearing about some new feature like LakehouseIQ!!

Quan · 09-22-2021

Hello all, I'm trying to pull table data from databricks tables that contain foreign language characters in UTF-8 into an ETL tool using a JDBC connection. I'm using the latest Simba Spark JDBC driver available from the Databricks website.The issue i...

Quan · 10-01-2021

Hello User, I actually found the solution to this issue and it partially related to what you suggested.Initially I did try the UseUnicodeSqlCharacterTypes=1 but that did not make a difference.Ultimately I realized that the issue was with the JAVA sys...

Quan · 09-23-2021

Yeah I saw that same post earlier and tried adding those properties as jdbc url properties but it didn't work. I think each driver has its own implementation of url properties that you can use and they are just not there for the Simba Driver but avai...

Quan · 09-23-2021

Yes the tool could read the parquet files but in this instance it would not be optimal do so as there can by multiple versions of the parquet organized in date_time_stamp sub folders. The Table is updated to use the latest version so I just have to r...

Quan · 09-23-2021

Hi Werners, the issue is not Databricks (all of the data looks fine and in proper encoding when I look at it there), the issue is the SIMBA JDBC Driver which by default appears to be bringing over columns of datatype STRING as SQL_VARCHAR instead of ...

Databricks Community

User Stats

User Activity

The 2023 Data & AI Summit is great!

How to properly load Unicode (UTF-8) characters from table over JDBC connection using Simba Spark Driver

Re: How to properly load Unicode (UTF-8) characters from table over JDBC connection using Simba Spark Driver

Re: How to properly load Unicode (UTF-8) characters from table over JDBC connection using Simba Spark Driver

Re: How to properly load Unicode (UTF-8) characters from table over JDBC connection using Simba Spark Driver

Re: How to properly load Unicode (UTF-8) characters from table over JDBC connection using Simba Spark Driver