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



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

i've been using table range decorators feature daily since may in order query info lastly 7 days in of tables.

since 2 weeks, i've noticed info missing when utilize feature. example, if query results lastly 7 days (by adding "@-604800000--1" table), info missing opposed if query on whole table (without table decorator).

i wonder explain , if there prepare coming address this?

if can help bigquery team, i've noticed when using table decorators info missing oct 16th between around 16:00 , 20:00 utc time.

for bigquery team here 2 jobs ids info missing: job_-xtl4pliyhnjq5wemnssvqdmd6u , job_9asnxqq_swjcd1emmiq6smppxlq

and 1 job id info correct(without decorators): job_qbcrwygbqv0bzdhreqevrlyh-mm

this known issue table decorators containing time range. due bug in bigquery, possible time ranges omit info should included within time range.

we're working on prepare , plan have released next week. after prepare deployed time range decorators should 1 time again work expected.

google-bigquery

Comments

Popular posts from this blog

php - Edges appear in image after resizing -

ios8 - iOS custom keyboard - preserve state between appearances -

Delphi change the assembly code of a running process -