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

Use OffsetIndex to Prune IO in ParquetRecordBatchStream #2426

Closed
tustvold opened this issue Aug 12, 2022 · 1 comment · Fixed by #2473
Closed

Use OffsetIndex to Prune IO in ParquetRecordBatchStream #2426

tustvold opened this issue Aug 12, 2022 · 1 comment · Fixed by #2473
Assignees
Labels
enhancement Any new improvement worthy of a entry in the changelog parquet Changes to the parquet crate

Comments

@tustvold
Copy link
Contributor

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

Even when there is an active row selection, async_reader::ReaderFactory::read_row_group will still fetch an entire column chunk from object storage.

Describe the solution you'd like

In the event that we have an OffsetIndex we can identify the pages that overlap with the row selection, and only fetch the corresponding byte ranges.

Describe alternatives you've considered

We could not do this

Additional context

This will likely benefit from ObjectStore::get_ranges added in #2336 being integrated into DataFusion to ensure the more granular ranges don't result in a regression, by making lots of small get requests

@tustvold tustvold added the enhancement Any new improvement worthy of a entry in the changelog label Aug 12, 2022
@thinkharderdev
Copy link
Contributor

I can take a crack at this.

@alamb alamb changed the title Use OffsetIndex to Prune IO in ParquetRecordBatchStream Use OffsetIndex to Prune IO in ParquetRecordBatchStream Aug 17, 2022
@alamb alamb added the parquet Changes to the parquet crate label Aug 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement Any new improvement worthy of a entry in the changelog parquet Changes to the parquet crate
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants