Are asynchronous batch queries also limited by maximum response size?

Question

I intend to run batch queries in order to amend some fields value and insert the result in another table. As an example:

bq --nosync query --batch --destination_table=datasetId.anotherTable "SELECT field0+1, field1, field2 FROM datasetId.someTable"

But I get this error:

Job Type    State      Start Time      Duration   Bytes Processed  
---------- --------- ----------------- ---------- ----------------- 
query      FAILURE   06 Sep 11:09:58   0:00:04                     

Errors encountered during job execution. Response too large to return.

Answer 1

Yes, currently batch queries have the same limit on response size as non-batch queries.

However, you can use the --allow_large_results flag and set a destination table for queries that have larger result sizes.