bigquery excel连接器 - 查询大于256个字符 [英] bigquery excel connector - query larger than 256 char

问题描述

我无法使用excel连接器在bq中运行长查询（280个字符）。

开发者指南说：

注意：如果您的查询长于256个字符，Excel将不允许您运行查询。
将查询拆分为多个部分，并将每个部分粘贴到多个相邻的单元格中。

我试过拆分一个查询但无法将其发布到旁边或下面的单元格中。

有没有办法让这项工作成功？

解决方案

更新：

我已经确认将查询的多个部分放在相邻的单元格中工作正常。我在Excel 2011 for Mac 2011上运行了一个长度为757个字符的查询。

将查询放入相邻的单元格后，需要将查询参数值定义为范围，如下所示：

  = Sheet1！$ B $ 7：$ B $ 11 
  
 
 
 
仅供参考 -  Excel中的 len（）函数在执行此操作时非常方便。  
 
 
旧回复：
 
 
 
我发送了一条消息给写这个功能/文档的工程师。在此期间（作为解决方法），您应该能够打开文本编辑器并修改您已下载到的.iqy文件。
  直接包含您的查询。  
I am unable to run a long query (280 char) in bq using the excel connector. 

The developers guide says:

  
Note: If your query is longer than 256 characters, Excel will not allow you to run the query. 
  Split your query into parts and paste each of those parts in multiple adjacent cells.
I have tried splitting the one query but can't get this to work either posting into a cell beside or below. 

Is there a way to make this work? I have run shorter queries fine.
解决方案
Update:

I've confirmed that placing multiple parts of the query in adjacent cells works fine.  I ran a query with a length of 757 characters on Excel for Mac 2011.

After placing your query in adjacent cells, you then need to define the query parameter value as a range, like this:
=Sheet1!$B$7:$B$11
FYI - the len() function in Excel comes in handy when doing this.  

Old Response:

I've sent a note to the engineer who wrote that feature/doc.  Will let you know.

In the meantime (as a workaround), you should be able to open up a text editor and modify the .iqy file you've downloaded to include your query directly. 

                        
这篇关于bigquery excel连接器 - 查询大于256个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！