search

sijocherian / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

allowLargeResults doesn't work with LIMIT #276

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Sample Query 1
SELECT *
FROM [publicdata:samples.github_timeline] LIMIT 5000000

Sample Query 2
SELECT *
FROM [publicdata:samples.github_timeline] LIMIT 500

Sample Query 1 will return error "Response too large to return. Consider 
setting allowLargeResults to true in your job configuration" even when 
destination table is specified. Sample Query 2 works though

This issue can be seen in both web GUI and API.

Original issue reported on code.google.com by r...@audiencepi.com on 26 Jun 2015 at 6:13

GoogleCodeExporter commented 8 years ago 
It is not enough to specify destination table, the "Allow Large Results" 
checkbox in UI also needs to be set. Please note that performance of LIMIT 
queries with AllowLargeResults will be worse than those without LIMIT, since 
LIMIT queries are not parallelizable.

Original comment by mos...@google.com on 26 Jun 2015 at 6:44

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
I missed out the info on "Allow Large Results" in my previous post but yes, the 
field is checked and the problem still exist.

Original comment by r...@audiencepi.com on 26 Jun 2015 at 7:12

GoogleCodeExporter commented 8 years ago 
I used your Sample Query 1 with AllowLargeResults set and it worked for me. Do 
you have job id for the failed query so I can look into it.

Original comment by mos...@google.com on 26 Jun 2015 at 7:17

GoogleCodeExporter commented 8 years ago 
clean-phoenix-86807:job_S_iVtzcH17EcU0bCaxLYp4bGFjk

Original comment by r...@audiencepi.com on 26 Jun 2015 at 7:21