TypeError(_NEED_TABLE_ARGUMENT) error using read_gbq

[Bizetremi]

Hello,

Version 0.17.0 introduced the error below when using read_gbq.

Example query used

UPDATE mydb.mytable set field1 = null
                             WHERE field1 = 'string' ;
UPDATE  mydb.mytable set field2 = null
                             WHERE field2 < 0

Environment details

• OS type and version:
• Python version: 3.7
• pandas-gbq version: 0.17.0

Code example

pandas_gbq.read_gbq(
                sql,
                project_id=project_id,
                dialect='standard',
                progress_bar_type=None,
                use_bqstorage_api=True,
                max_results=0,)

Stack trace

File "/layers/google.python.pip/pip/lib/python3.7/site-packages/pandas_gbq/gbq.py", line 870, in read_gbq dtypes=dtypes, File "/layers/google.python.pip/pip/lib/python3.7/site-packages/pandas_gbq/gbq.py", line 499, in run_query query_reply.destination, max_results=max_results File "/layers/google.python.pip/pip/lib/python3.7/site-packages/google/cloud/bigquery/client.py", line 3780, in list_rows raise TypeError(_NEED_TABLE_ARGUMENT) TypeError: The table argument should be a table ID string, Table, or TableReference

Best,

[meredithslota]

Actually, this might have been intentional — there were known breaking changes in 0.17.0 as per #477 — but I'm not totally sure.

[meredithslota]

Copying out the stacktrace for my own readability:

File "/layers/google.python.pip/pip/lib/python3.7/site-packages/pandas_gbq/gbq.py", line 870, in read_gbq dtypes=dtypes, File "/layers/google.python.pip/pip/lib/python3.7/site-packages/pandas_gbq/gbq.py", line 499, in run_query query_reply.destination, max_results=max_results File "/layers/google.python.pip/pip/lib/python3.7/site-packages/google/cloud/bigquery/client.py", line 3780, in list_rows raise TypeError(_NEED_TABLE_ARGUMENT) TypeError: The table argument should be a table ID string, Table, or TableReference

[tswast]

Hmmm... It appears that this is interpreting your query string as a table name. Perhaps we got the regex to detect whitespace incorrect?

Nevermind, it is in the run_query method.

File "/layers/google.python.pip/pip/lib/python3.7/site-packages/pandas_gbq/gbq.py", line 499, in run_query query_reply.destination, max_results=max_results File "/layers/google.python.pip/pip/lib/python3.7/site-

Somehow query_reply.destination is not being populated. Since this is a DML query, perhaps we need some special case for that -- since it might not have a destination table?

[tswast]

I can reproduce this error with a system test, though it seems the regression happened between 0.11.0 and 0.12.0, unless there was a brief fix for DML queries since then.

[tswast]

Fix #483 has been mailed for review