BigQuery: Why does Table Range Decorators return wrong result sometimes? -


I table range decorator to query the data from the last 7 days to use daily feature since only May since I have some tables

2 weeks, I'd noticed that whenever I use that feature some data is lost, for example, if (add table "@ -604 800 000 - 1 "), get a question of getting results of the last 7 days, some As the data (without a table if I will be missing as opposed to the query on the entire desk decorator).

I wonder what this can explain and if there is a fix coming to its solution soon?

The BigQuery can help the team, I have noticed that when the table decorator using some had missing data for us between 16 October and 20:00 UTC of 16 October.

BigQuery are here 2 job ID for the team is coming where the missing data: job_-xtL4PlIYhNjQ5weMnssvqDmd6U , job_9ASNxqq_swjCd1eMmiQ6SmPpxlQ

< p> 1 job ID where the data is correct (without decorators): job_QbcRwYGbQv0BZdHreQEvRlYh- mm

with a known table this issue

this is due to a bug in BigQuery up with a time limit, or it should be included in the data for possible time that deadline Karan The choice ranges.

We are working on a fix and plan to issue it next week. After this fix is ​​deployed, time-range decorators should work again as expected.


Comments

Popular posts from this blog

winforms - C# Form - Property Change -

javascript - amcharts makechart not working -

java - Algorithm negotiation fail SSH in Jenkins -