'使用目标表和'允许大量结果'选项时'响应太大而无法返回'“错误 [英] 'Response too large to return' error when using a destination table and 'Allow Large Results' option

问题描述

我试图执行一个查询，该查询连接一个大约1毫米行的表，并将结果通过BigQuery UI保存到目标表中。我检查了允许大型结果选项。然而，在30多岁之后，它的回应是'回复太大而不能回复'。当我取消选中允许大型结果选项时，它可以正常工作。 （它运行约5分钟）。
我最初在自动化过程中使用BigQueryJava API运行此查询时遇到了这个问题，它使用相同的选项。

我禁用了BigQuery UI中的选项。

所以对我来说有一个解决方法，但是这个查询作业一直运行良好，直到今天还有'Allow Large Results'选项。 / p>

查询基本上是这样的：

  SELECT t1.id， t1.a，t1.b，t1.c，t2.d，t2.e 
 FROM table1 t1 
 LEFT JOIN EACH table2 t2 
 ON t1.id = t2.id AND t1。 a = t2.a 
  

解决方案

在查询准备。我们正在修复。
编辑补充：2013年修正。

I'm trying to perform a query which joins a table of about 1 mln rows with a smaller one and saving the results to a destination table via the BigQuery UI. I've checked the option 'Allow Large Results'. However after 30s it responds with 'Response too large to return.'. When I uncheck the option 'Allow Large Results' it works fine. (it runs then for about 5 mins). I initially ran into this issue when running this query job using the BigQueryJava API in an automated process, using the same options.

The query runs also fine when I disable the options in the BigQuery UI.

So there is a workaround for me, but this query job ran fine until today with the 'Allow Large Results' option.

The query is basically is like:

SELECT t1.id, t1.a, t1.b, t1.c, t2.d, t2.e
FROM table1 t1 
LEFT JOIN EACH table2 t2 
ON t1.id = t2.id AND t1.a = t2.a

解决方案

Looks like there is a bug in query preparation. We're working on a fix. Edited to add: This was fixed in 2013.

这篇关于'使用目标表和'允许大量结果'选项时'响应太大而无法返回'“错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！