title: BigQuery: Why does Table Range Decorators return wrong result sometimes?
body: <p>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. </p>
  
  <p>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). </p>
  
  <p>I wonder what could explain this and if there is a fix coming soon to address this?</p>
  
  <p>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. </p>
  
  <p>For the BigQuery team here are 2 jobs ids where some data is missing: <em>job_-xtL4PlIYhNjQ5weMnssvqDmd6U</em> , <em>job_9ASNxqq_swjCd1eMmiQ6SmPpxlQ</em> </p>
  
  <p>and 1 job id where data is correct(without decorators): job_QbcRwYGbQv0BZdHreQEvRlYh-mM</p>