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
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
Post a Comment