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屋！