为什么BigQuery加载作业统计信息会返回查询信息？ [英] Why does BigQuery load job statistics return query information?

问题描述

我们有一些从GCS获取文件的加载作业，并将它们加载到BigQuery中进行分析。我们使用 JobConfigurationLoad

如果这是一个加载作业，为什么它会返回查询信息？

解决方案

Wh在你看到的是一个错误报告负载工作的细节。由于BigQuery加载作业不应该填充查询处理统计信息（我们利用我们的查询执行树来辅助一些加载作业），所以我们在内部打开了一个问题。

值得注意的是，尽管处理统计信息字段的填充方式与我们报告查询分析使用情况的方式相同，但这些加载作业不会产生任何查询分析成本。

We've got some load jobs that scoop up files from GCS, and load them into BigQuery for analysis. We use the JobConfigurationLoad class in the BigQuery Java API to achieve this.

It works fine.

However, we've noticed that the JobStatistics class that is returned when the job finishes contains "query" and "totalBytesBilled" information.

If this is a load job, why does it return query information?

解决方案

What you're seeing is an error reporting details about the load job. We've got an issue open internally as BigQuery load jobs should not be populating the query processing statistics (we're leveraging our query execution tree to assist with some load jobs).

It is worth noting that even though the processing stats fields are populated in the same way we report query analysis usage, these load jobs did not contribute any query analysis costs.

这篇关于为什么BigQuery加载作业统计信息会返回查询信息？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！