BigQuery空转返回什么? [英] What does a BigQuery dry run return?

问题描述

BigQuery文档说:

The BigQuery docs say:

在表的较小分区而不是一个大表上测试查询.如果使用API​​，请验证查询的语法并使用dryRun标志获取数据处理统计信息."

"Test your queries on smaller partitions of the table rather than one large table. If using the API, validate queries for syntax and get data processing statistics using the dryRun flag."

但是他们也说，对于dryRun:

But they also say, for dryRun:

如果设置，则实际上不运行查询.有效查询将返回空响应，而无效查询将返回与非空运行相同的错误.默认值为false. "

"If set, don't actually run the query. A valid query will return an empty response, while an invalid query will return the same error it would if it wasn't a dry run. The default value is false."

这些似乎是矛盾的，还是我错过了什么?

These seem to be contradictory, or am I missing something?

推荐答案

我看到它们之间有些不同步，可以进行一些澄清.

I see how these are a bit out of sync and could use some clarification.

这是dryRun的另一种描述，它更加准确.来自 https://cloud.google.com/bigquery/docs/reference/v2/作业，搜索dryRun:

Here's another description of dryRun that is more accurate. From https://cloud.google.com/bigquery/docs/reference/v2/jobs, search for dryRun:

[可选]如果已设置，请不要实际运行此作业.有效的查询将 返回带有一些处理统计信息的大部分为空的响应，而 无效的查询将返回与错误查询相同的错误 空运行.非查询作业的行为是不确定的.

[Optional] If set, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. Behavior of non-query jobs is undefined.

它看起来像 https://cloud.google.com/bigquery/launch-checklist 文档只是缺少两个独立建议之间的要点.

It looks like the https://cloud.google.com/bigquery/launch-checklist documentation is just missing a bullet point between two independent suggestions.

我已经记录了一个内部跟踪错误，以进行清理.感谢您引起我们的注意！

I've logged an internal tracking bug for cleaning this up. Thanks for bringing this to our attention!

这篇关于BigQuery空转返回什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！