Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

perf: don't fetch rows when waiting for query to finish#400

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 ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Conversation

@tswast
Copy link
Contributor

@tswasttswast commentedNov 24, 2020
edited
Loading

When there are large result sets, fetching rows while waiting for the
query to finish can cause the API to hang indefinitely. (This may be due
to an interaction between connection timeout and API timeout.)

This reverts commit86f6a51 (#374).

Thank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:

  • Make sure to open an issue as abug/issue before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
  • Ensure the tests and linter pass
  • Code coverage does not decrease (if any source code was changed)
  • Appropriate docs were updated (if necessary)

Fixesgoogleapis/python-bigquery-pandas#343
Fixes#394 🦕

When there are large result sets, fetching rows while waiting for thequery to finish can cause the API to hang indefinitely. (This may be dueto an interaction between connection timeout and API timeout.)This reverts commit86f6a51 (googleapis#374).
@tswasttswast requested review froma team andpmakaniNovember 24, 2020 19:33
@google-clagoogle-clabot added the cla: yesThis human has signed the Contributor License Agreement. labelNov 24, 2020
@product-auto-labelproduct-auto-labelbot added the api: bigqueryIssues related to the googleapis/python-bigquery API. labelNov 24, 2020
@tswasttswast requested review fromshollyman and removed request forpmakaniNovember 24, 2020 19:33

api_request.assert_called_once_with(method="GET",path=path,query_params={})

deftest_iterate_with_cached_first_page(self):
Copy link
ContributorAuthor

Choose a reason for hiding this comment

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

I add these tests to fix coverage.

Perhaps instead I should also be reverting the changes from#384 ?

Copy link
Contributor

Choose a reason for hiding this comment

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

The alternative I'd consider is doing a flag-based feature, so users can turn on the latency changes (or flip default, and provide an opt-out while we diagnose these other cases).


api_request.assert_called_once_with(method="GET",path=path,query_params={})

deftest_iterate_with_cached_first_page(self):
Copy link
Contributor

Choose a reason for hiding this comment

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

The alternative I'd consider is doing a flag-based feature, so users can turn on the latency changes (or flip default, and provide an opt-out while we diagnose these other cases).

@tswasttswast added the automergeMerge the pull request once unit tests and other checks pass. labelNov 24, 2020
@tswasttswast mentioned this pull requestNov 24, 2020
7 tasks
@gcf-merge-on-greengcf-merge-on-greenbot merged commit730df17 intogoogleapis:masterNov 24, 2020
@gcf-merge-on-greengcf-merge-on-greenbot removed the automergeMerge the pull request once unit tests and other checks pass. labelNov 24, 2020
@tswasttswast deleted the issue394-revert-rows-cache branchNovember 16, 2023 20:43
Sign up for freeto join this conversation on GitHub. Already have an account?Sign in to comment

Reviewers

@shollymanshollymanshollyman approved these changes

Assignees

No one assigned

Labels

api: bigqueryIssues related to the googleapis/python-bigquery API.cla: yesThis human has signed the Contributor License Agreement.

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

simple query hangs in 0.14.1, works in 0.13.3 increased memory usage in 2.4.0

2 participants

@tswast@shollyman

[8]ページ先頭

©2009-2025 Movatter.jp