Skip to content

Comments

Use ParquetMetaDataReader to load page indexes in SerializedFileReader::new_with_options#6506

Merged
alamb merged 1 commit intoapache:masterfrom
etseidl:filtered_page_indexes
Oct 7, 2024
Merged

Use ParquetMetaDataReader to load page indexes in SerializedFileReader::new_with_options#6506
alamb merged 1 commit intoapache:masterfrom
etseidl:filtered_page_indexes

Conversation

@etseidl
Copy link
Contributor

@etseidl etseidl commented Oct 3, 2024

Which issue does this PR close?

Closes #6491.

Rationale for this change

Reduce the file I/O needed to read in the page indexes.

What changes are included in this PR?

If page indexes are needed, create a new ParquetMetaDataReader using the filtered set of row groups. This will do a single read to get the bytes necessary to instantiate the needed page index structures, rather than two reads per row group. An alternative approach would be to read all the needed structures up front and then prune them, but that would mean reading page indexes that will just be thrown away.

Are there any user-facing changes?

No

@github-actions github-actions bot added the parquet Changes to the parquet crate label Oct 3, 2024
#[test]
fn test_file_reader_filter_row_groups_and_range() -> Result<()> {
let test_file = get_test_file("alltypes_plain.parquet");
let test_file = get_test_file("alltypes_tiny_pages.parquet");
Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Switch to a test file that contains page indexes.


let mut metadata = metadata_builder.build();

// If page indexes are desired, build them with the filtered set of row groups
Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

The key here is that we're only pulling page indexes for row groups that survived the predicate filtering above.

Copy link
Contributor

@alamb alamb left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thank you @etseidl -- this looks great to me

metadata.row_group(0).column(0).data_page_offset()
);

// read non-contiguous row groups
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

this is great -- than you for adding these tests for predicate

metadata_builder = metadata_builder
.set_column_index(Some(columns_indexes))
.set_offset_index(Some(offset_indexes));
let mut reader =
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

this makes sense to switch the metadata.

@alamb alamb merged commit 7b30881 into apache:master Oct 7, 2024
@alamb
Copy link
Contributor

alamb commented Oct 7, 2024

Thanks again @etseidl

@etseidl etseidl deleted the filtered_page_indexes branch October 7, 2024 19:09
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

parquet Changes to the parquet crate

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Improve page index metadata loading in SerializedFileReader::new_with_options

3 participants