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

Limit bigquery records returned #716

Closed
scsmithr opened this issue Mar 6, 2023 · 0 comments · Fixed by #2754
Closed

Limit bigquery records returned #716

scsmithr opened this issue Mar 6, 2023 · 0 comments · Fixed by #2754
Labels
bug Something isn't working

Comments

@scsmithr
Copy link
Member

scsmithr commented Mar 6, 2023

Context

Currently limit is ignore during execution. Obviously not great to read everything if a limit is provided.

Expected

Limit is respected.

Actual

Limit ignored.

Impact

@scsmithr scsmithr added the bug Something isn't working label Mar 6, 2023
tychoish added a commit that referenced this issue Mar 18, 2024
Closes #716

----

I found this as I was looking through the issues earlier today. 

One concern with this (and limit pushdowns in general,) is that we
could be _under_ reporting data in these cases:

Imagine we only partially push down a predicate but we completly push
down the limit. If we get `n` rows back from the data source, but then
further filter it down, then we've returned fewer than the target
number of rows. Right? 

This isn't new, and I'm not sure we _shouldn't_ do this because of
that, and also I could imagine datafusion passing in different limits
than what the user specified.

---------

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Co-authored-by: Vaibhav Rabber <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants