Google BigQuery 相同的查询给出不同的结果 [英] Google BigQuery same queries give different results

问题描述

我运行了 2 个非常相似的查询.唯一的区别是一种是按字段名称分组，另一种是按字段数分组(即1,2,3).

I have run 2 very similar queries. The only difference is one is grouping by the names of the fields and the other one is grouping by the number of the fields (i.e. 1,2,3).

这两个查询应该给出完全相同的结果，因为查询中没有不同的计数.然而，事实并非如此.一个查询得到 5 条记录，而另一个查询只给出 1 条记录.

These 2 queries should be giving exactly the same result as there is no count distinct in the queries. However, it's not the case. One query gets 5 records and the other one gives only 1 record.

我想知道是否有人可以提供帮助.

I am wondering if anyone could help.

以下是作业 ID 和查询:

Here are the job ids and queries:

作业 ID 1:631095067040:job_0NLPcGFK_umGVdyY0fuFnemkos0

Job ID 1: 631095067040:job_0NLPcGFK_umGVdyY0fuFnemkos0

选择 ID，频道
来自 my.dataset
Id in ('aaa','bbb','ccc','ddd','eee')
按 ID、频道分组；

select Id, Channel
from my.dataset
where Id in ('aaa','bbb','ccc','ddd','eee')
group each by Id, Channel;

作业 ID 2:631095067040:job_NlWyxr0N4fi5ZnVKYDAVFr7qcew

Job ID 2: 631095067040:job_NlWyxr0N4fi5ZnVKYDAVFr7qcew

选择 ID，频道
来自 my.dataset
Id in ('aaa','bbb','ccc','ddd','eee')
按 1,2 分组

select Id, Channel
from my.dataset
where Id in ('aaa','bbb','ccc','ddd','eee')
group each by 1,2

谢谢！

推荐答案

我们(BigQuery 团队)正在跟踪一些查询返回陈旧结果(即返回基于陈旧数据的结果)的问题.

We (the BigQuery team) are tracking an issue where some queries are returning stale results (that is, return results that are based on stale data).

此问题已解决，如果您仍然看到问题，请ping此线程或打开另一个问题.

This issue has been resolved, please ping this thread or open another issue if you continue to see problems.

这篇关于Google BigQuery 相同的查询给出不同的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！