BigQuery：为什么Table Range Decorators有时会返回错误的结果？ [英] BigQuery: Why does Table Range Decorators return wrong result sometimes?

问题描述

自从5月份以来，我一直在使用Table Range Decorators功能，以便仅查询我的某些表中最近7天的数据。

自2周以来，我注意到当我使用该功能时有时会丢失一些数据。例如，如果执行查询以获取最近7天的结果（通过将@ -604800000--1添加到表），则会丢失一些数据，而不是如果我在整个表上查询（没有表格装饰）。

我不知道有什么可以解释这一点，如果有解决方案即将解决这个问题？

如果这可以帮助BigQuery团队，我注意到，在使用Table Decorators时，在16:00和20:00 UTC时间之间，10月16日我们缺少了一些数据。

对于BigQuery团队，这里有2个工作id，其中缺少一些数据： job_-xtL4PlIYhNjQ5weMnssvqDmd6U ， job_9ASNxqq_swjCd1eMmiQ6SmPpxlQ

和1个工作ID，其中数据正确（无装饰器）：job_QbcRwYGbQv0BZdHreQEvRlYh-mM

解决方案这是包含时间范围的table decorators的一个已知问题。由于BigQuery中存在一个错误，某些时间范围可能会忽略应包含在时间范围内的数据。

我们正在制定修复计划让它在下周发布。在部署此修复程序后，时间范围装饰器应再次按预期工作。

I've been using the Table Range Decorators feature daily since May in order to only query the data from the last 7 days in some of my tables.

Since 2 weeks, I've noticed that sometimes some data is missing when I use that feature. For example, if do a query to get the results for the last 7 days (by adding "@-604800000--1" to table), some data will be missing as opposed to if I query on the whole table (without a table decorator).

I wonder what could explain this and if there is a fix coming soon to address this?

If this can help the BigQuery team, I've noticed that when using Table Decorators some data was missing for us for October 16th between around 16:00 and 20:00 UTC time.

For the BigQuery team here are 2 jobs ids where some data is missing: job_-xtL4PlIYhNjQ5weMnssvqDmd6U , job_9ASNxqq_swjCd1eMmiQ6SmPpxlQ

and 1 job id where data is correct(without decorators): job_QbcRwYGbQv0BZdHreQEvRlYh-mM

解决方案

This is a known issue with table decorators containing a time range. Due to a bug in BigQuery, it is possible for certain time ranges to omit data that should be included within the time range.

We're working on a fix and plan to have it released next week. After this fix is deployed time range decorators should again work as expected.

这篇关于BigQuery：为什么Table Range Decorators有时会返回错误的结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！