Skip to content

Implement #2534 - add parquet_file_metadata function that supports scanning top-level file metadata #9793

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
Merged
merged 5 commits into from
Nov 27, 2023
Merged

Implement #2534 - add parquet_file_metadata function that supports scanning top-level file metadata #9793

merged 5 commits into from
Nov 27, 2023
+159 −25

Conversation

Mytherin
Copy link
Collaborator

Implements #2534

This PR adds the last missing piece of the Parquet metadata scanning, which is the top-level file metadata.

D FROM parquet_file_metadata('data/parquet-testing/arrow/alltypes_dictionary.parquet');
┌──────────────────────┬─────────────────────────────────────────────────┬──────────┬────────────────┬────────────────┬──────────────────────┬─────────────────────────────┐
│      file_name       │                   created_by                    │ num_rows │ num_row_groups │ format_version │ encryption_algorithm │ footer_signing_key_metadata │
│       varchar        │                     varchar                     │  int64   │     int64      │     int64      │       varchar        │           varchar           │
├──────────────────────┼─────────────────────────────────────────────────┼──────────┼────────────────┼────────────────┼──────────────────────┼─────────────────────────────┤
│ data/parquet-testi…  │ impala version 1.3.0-INTERNAL (build 8a48ddb1…  │        2 │              1 │              1 │ NULL                 │ NULL                        │
└──────────────────────┴─────────────────────────────────────────────────┴──────────┴────────────────┴────────────────┴──────────────────────┴─────────────────────────────┘

In addition, we also add a file_name to the parquet_kv_metadata function to make it compatible with the others.

Now all Parquet file metadata should be scannable using the below functions.

Function Metadata
parquet_file_metadata Top-Level File Meta Data
parquet_metadata Row-Group Metadata
parquet_schema Schema Metadata
parquet_kv_metadata Optional Key-Value Pairs

@Mytherin Mytherin added the Needs Documentation Use for issues or PRs that require changes in the documentation label Nov 24, 2023
@Mytherin Mytherin linked an issue Nov 24, 2023 that may be closed by this pull request
Enhancement: support all parquet file metadata #2534
Closed
@duckdblabs-bot duckdblabs-bot mentioned this pull request Nov 24, 2023
Closed
@github-actions github-actions bot marked this pull request as draft November 24, 2023 13:36
@Mytherin Mytherin marked this pull request as ready for review November 24, 2023 13:37
@github-actions github-actions bot marked this pull request as draft November 24, 2023 15:51
@Mytherin Mytherin marked this pull request as ready for review November 24, 2023 16:08
@github-actions github-actions bot marked this pull request as draft November 25, 2023 11:22
@Mytherin Mytherin marked this pull request as ready for review November 25, 2023 11:22
@Mytherin Mytherin mentioned this pull request Nov 25, 2023
Merged
@szarnyasg szarnyasg mentioned this pull request Nov 26, 2023
Merged
@Mytherin Mytherin merged commit 40d29a5 into duckdb:main Nov 27, 2023
@Mytherin Mytherin mentioned this pull request Nov 27, 2023
Closed
@Mytherin Mytherin deleted the allparquetmetadata branch December 4, 2023 11:44
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request Dec 14, 2023
@krlmlr
chore: Update vendored sources to duckdb/duckdb@40d29a5
30d01ff 
Merge pull request duckdb/duckdb#9793 from Mytherin/allparquetmetadata
Merge pull request duckdb/duckdb#9797 from Mause/bugfix/python-3.12-minimal
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
Needs Documentation Use for issues or PRs that require changes in the documentation
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Enhancement: support all parquet file metadata
1 participant
@Mytherin