错误：响应太大而无法在大查询中返回 [英] Error: Response too large to return in big query

问题描述

我试图运行查询 select * from tablename 。
但它会抛出错误，如错误：响应太大而无法返回。

我能够处理一些其他表包含数据TB。但我得到这个包含294 MB的表的错误。

我能够通过选择列名来选择列表，但有些限制无法处理所有选择查询中的列。
在我的选择查询中，我总共有26列，但是我能够选择16列而没有错误。
从表名中选择column1，column2，column3，.... column16

是否与列有关系？表格大小。

请帮我解决这个问题。

大查询表详情：

共计记录：683,038

表格大小：294 MB

没有列：26

解决方案

在作业配置中将allowLargeResults设置为true。您还必须使用allowLargeResults标志指定一个目标表。

如果通过API查询，

 configuration：
 {
query：
 {
allowLargeResults：true，
query：select uid from [project：dataset.table]
destinationTable：[project：dataset.table] 
 
} 
} 
   
 
如果使用bq命令行工具，
 
 
 
 
 $ bq query  - -allow_large_results --destination_tabledataset.table从[project：dataset.table]中选择uid
 
如果使用浏览器工具， 
 
 
 
 
 
 
点击'启用选项'结果'
 
 
 
 
 
I am trying to run the query "select * from tablename ".
But it throws error like "Error: Response too large to return".


I was able to process some other table which contains TB of data. But I am getting this error for the table which contain 294 MB.

I was able to select the table by selecting the column name with some limitation not able to process all the column in select query. 
In my select query I have totally 26 column but I was able to select 16 column without error.
"select column1,column2,column3,....column16 from tablename".

Is there any relation with column and size of the table.

Please help me to fix this issue.

Big Query table details:

Total Records: 683,038

Table Size: 294 MB

No of Column: 26
解决方案
Set allowLargeResults to true in your job configuration. You must also specify a destination table with the allowLargeResults flag.

If querying via API,
"configuration": 
  {
    "query": 
    {
      "allowLargeResults": true,
      "query": "select uid from [project:dataset.table]"
      "destinationTable": [project:dataset.table]

    }
  }
If using the bq command line tool,

  
$ bq query --allow_large_results --destination_table "dataset.table" "select uid from [project:dataset.table]"
If using the browser tool, 

  

  
Click 'Enable Options'
  
Select 'Allow Large Results'
  


                        
这篇关于错误：响应太大而无法在大查询中返回的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！