Clever Geek Handbook

Allow Large Results option fails in browser

I am trying to query a relatively small table (1.3M rows, 517MB) and render order by

in one of the columns. The results are configured to be written to another table and "Allow large results". But BigQuery still gives the error:

Error: Response too large to return. Consider setting allowLargeResults to true in your job configuration. For more details, see https://cloud.google.com/bigquery/querying-data#largequeryresults

Job example: gdfp-7415: job_asEyhGwqdrCwllhxCOGGE5osHlE

Why doesn't it work?

enter image description here

+3


source to share


1 answer


This does not work:

SELECT *
FROM [wikipedia_benchmark.Wiki10M]

"Response too large to return."

It works:

SELECT *
FROM [wikipedia_benchmark.Wiki10M]
[x] Allow Large Results


This does not work:

SELECT *
FROM [wikipedia_benchmark.Wiki10M]
ORDER BY title
[x] Allow Large Results

"Response too large to return."

The problem is that you cannot use "ORDER BY" with "Allow Large Results". This is because "allow big results" distributes the output job rather than collecting everything in one node. Since the output is allocated, there is no root node to start sorting.

The clear problem is that the error message is not clear. Sorry for this!

+3


source






More articles:


All Articles