Is there a known issue regarding Databricks JDBC driver character values such as Japanese etc?

151640
Databricks Partner

‎11-02-2022 09:45 AM

A Parquet file contains character data for various languages and is shown by the Data Explorer UX. A simple "select *" query using the Databricks JDBC driver (version 2.6.29) with a tool such as SQLSquirrel displays invalid characters.

image

Preview file
113 KB
0 Kudos

Debayan
Databricks Employee
Databricks Employee

‎11-02-2022 11:41 PM

Hi @nigel campbell​ , Could you please look into https://community.databricks.com/s/question/0D53f00001LKG9ECAX/how-to-properly-load-unicode-utf8-cha... and let us know if this helps.

151640
Databricks Partner
In response to Debayan

‎11-03-2022 03:26 AM

That thread doesn't address the issue. The driver should return valid values by default as do many other products. Appears to be a fairly significant defect.

Anonymous
Not applicable

‎01-16-2023 09:59 PM

Hi @nigel campbell​ 

Hope everything is going great.

Does @Kaniz Fatma​  and @Debayan Mukherjee​ response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?

We'd love to hear from you.

Thanks!

0 Kudos

151640
Databricks Partner

‎01-17-2023 04:15 AM

The issue encountered has been confirmed to be a defect in the Databricks JDBC driver.

View solution in original post