谷歌大查询限制子句返回太多的行 [英] google big query limit clause returning too many rows

问题描述

在大查询中，我正在对来自GA的导出表执行查询。

我似乎无法得到大的查询来限制结果。这是一个简单的查询示例，非常基本。

  SELECT * FROM [1111111.ga_sessions_20140318] LIMIT 20000 
  

结果集返回，但有700万行！我已经尝试了这几种不同的方式，即。到表中，只返回结果集，使用缓存结果，不使用缓存结果等。
无论我尝试查询哪个表，它总是返回整个表。

除了将限制值从1000更改为20000之外，这与单击查询表按钮时查询大查询所提供的基本相同。

任何人都有什么见解？

正如原评问题所述：
$ b

是否有可能大查询中返回的
结果集底部显示的行数是我的20000主对象记录加
所有嵌套记录？

答案是肯定的：BigQuery会将限制应用于数字响应中的行数，但如果涉及嵌套记录，则这些记录将在输出中展平。

In big query I am running a query on exported tables from GA.

I can not seem to get big query to limit the results. Here is a sample query, quite basic.

SELECT * FROM [1111111.ga_sessions_20140318] LIMIT 20000

The result set returns but with 7 million+ rows! I have tried this several different ways, ie. out to a table, just return result set, use cache results, don't use cached results, etc. No matter which table I try to query it always returns the entire table.

This is basically the same as the sample query big query gives when clicking on the query table button except I changed the limit value from 1000 to 20000.

Anyone have any insight?

解决方案

As noted by the comment on the original question:

"Is it possible that the number of rows shown at the bottom of the result set returned in big query is my 20000 main object records plus all the nested records?"

The answer is yes: BigQuery will apply the limit to the number of rows in the response, but if there are nested records involved, those will be flattened in the output.

这篇关于谷歌大查询限制子句返回太多的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！