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 it load gzipped parquet files? #27

Open
anentropic opened this issue Apr 28, 2024 · 2 comments
Open

Can it load gzipped parquet files? #27

anentropic opened this issue Apr 28, 2024 · 2 comments

Comments

@anentropic
Copy link

anentropic commented Apr 28, 2024

AWS has an option to export an RDS db snapshot to parquet files in an S3 bucket. But the resulting files are gzipped

Is it possible to directly load them with the fdw, or I need to run a batch job to unzip them first?

Maybe this is a dumb question, the files are like part-00000-fa89fa59-af57-4db3-81f3-bba1597c6e56-c000.gz.parquet... is that just a parquet file with internal gzip compression? Can the fdw read that?

@hrkuma
Copy link

hrkuma commented May 7, 2024

Hello,

Maybe you can access such kind of file after merging #25 .

@lamdn1409
Copy link

@anentropic

parquet_s3_fdw does not support GZIP compression method. It supports the following methods: SNAPPY, ZSTD and UNCOMPRESSED.

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

3 participants