-
Notifications
You must be signed in to change notification settings - Fork 130
Closed
googleapis/python-bigquery
#400Labels
type: questionRequest for information or clarification. Not an issue.Request for information or clarification. Not an issue.
Description
SUMMARY_TABLE is very simple million-record table in bigquery, nothing but short strings, numbers, and a timestamp.
Installed pandas-gbq and got the 0.14.1 version.
Run
query = f"select * from {SUMMARY_TABLE} LIMIT 20000"
df = pd.read_gbq(query,
project_id=PROJECT_NAME,
dialect='standard',
progress_bar_type='tqdm',
)
and it works normally.
Run
query = f"select * from {SUMMARY_TABLE} LIMIT 50000"
df = pd.read_gbq(query,
project_id=PROJECT_NAME,
dialect='standard',
progress_bar_type='tqdm',
)
(or no LIMIT) and it runs forever. Note that I tried setting max_results and it didn't make any difference, even if set to less than 20000.
Uninstall 0.14.1, install 0.13.3, the problem is gone.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
type: questionRequest for information or clarification. Not an issue.Request for information or clarification. Not an issue.