exyi / pg2parquet

Export PostgreSQL table or query into Parquet file
Apache License 2.0
57 stars 11 forks source link

Encountered error while exporting nested list to parquet file format using pg2parquet utility #22

Closed guptashreyaa closed 3 months ago

guptashreyaa commented 3 months ago

Encountered below error: thread 'main' panicked at /home/ubuntu/.cargo/registry/src/index.crates.io-6f17d22bba15001f/tokio-postgres-0.7.10/src/row.rs:151:25: error retrieving column 1: error deserializing column 1: array contains too many dimensions note: run withRUST_BACKTRACE=1environment variable to display a backtrace pg2parquet probably should not crash in this way, could you please report a bug at https://github.com/exyi/pg2parquet/issues/new (ideally with the backtrace and some info on what you did)?

Below is the schema of the table: `Schema: root

exyi commented 3 months ago

Thanks for reporting the issue. I think it is because some of lists is multi-dimensional, which wasn't supported by pg2parquet. I added the support, it is in version 0.1.1. Note that the dimensionality is dropped during the export, as Parquet lists must have a single-dimension.

Could you please verify that it indeed resolves your issue?