Skip to content

Wait for Query hangs indefinitely for some queries #403

@willbowditch

Description

@willbowditch

I think this bug has been introduced by the wait_for_query tqdm helper in #352

Dropping the previous version resolves pipenv install google-cloud-bigquery==2.3.1.

Some queries now hang indefinitely at "query is running" or "complete":

    query_job = client.query(query, job_config=job_config)
    df = query_job.to_dataframe(progress_bar_type='tqdm')

image

However running the same without the progress bar returns the dataframe

    query_job = client.query(query, job_config=job_config)
    df = query_job.to_dataframe(progress_bar_type=None)

The following also returns the dataframe:

    query_job = client.query(query, job_config=job_config)
    df = query_job.to_dataframe(progress_bar_type=None)
    df = query_job.to_dataframe(progress_bar_type='tqdm')

image

Environment details

  • OS type and version: OS X 10.15.7
  • Python version: python --version 3.6.10
  • pip version: pip --version pip 20.2.4
  • google-cloud-bigquery version: pip show google-cloud-bigquery Version: 2.4.0

Metadata

Metadata

Labels

api: bigqueryIssues related to the googleapis/python-bigquery API.type: questionRequest for information or clarification. Not an issue.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions