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.

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

Can't read string from Parquet binary column #113

Open
HJK181 opened this issue Dec 16, 2024 · 1 comment
Open

Can't read string from Parquet binary column #113

HJK181 opened this issue Dec 16, 2024 · 1 comment

Comments

@HJK181
Copy link

HJK181 commented Dec 16, 2024

I'm using

  <dependency>
            <groupId>org.duckdb</groupId>
            <artifactId>duckdb_jdbc</artifactId>
            <version>1.1.3</version>
  </dependency>

to read Parquet files where I store string columns as org.apache.parquet.io.api.Binary. However, when trying to call DuckDBPreparedStament#getString I do get a DuckDBBlobResult.

image
image

@HJK181
Copy link
Author

HJK181 commented Dec 16, 2024

After lots of reading in the Parquet sections of the docs, I came across: https://duckdb.org/docs/configuration/overview.html via Google and found that I need to call SET binary_as_string = true to fix my problem.

This issue can be closed but it would be nice if any of the Parquet sections in the docs could catch up this well hidden (when you a searching Parquet related sections) configuration flag.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant