Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Convert Databricks type BINARY to VARCHAR #34

Open
kaklakariada opened this issue Sep 30, 2024 · 0 comments
Open

Convert Databricks type BINARY to VARCHAR #34

kaklakariada opened this issue Sep 30, 2024 · 0 comments
Labels
feature Product feature

Comments

@kaklakariada
Copy link
Collaborator

Many Databricks data types like ARRAY, MAP and STRUCT can be converted to VARCHAR without problem, see #15.

Mapping BINARY to VARCHAR does not work, because importing the data fails with the following message:

ETL-5402: JDBC-Client-Error: JDBC SQL Type for column=0 (starting at 0) value=-2 is unknown.

In order to import BINARY columns, the adapter needs to rewrite the pushdown query to cast the BINARY column to VARCHAR.
@kaklakariada kaklakariada added the feature Product feature label Sep 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature Product feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@kaklakariada