Google BigQuery running forever

Question

I'm running a BigQuery query everyday and it works perfectly but today (2015-08-10) it's taking forever (5,000sec+) and not returning the results or an error, just continue running..

Is there a problem with Google BigQuery today, or is this a bug with BigQuery?

the query job id:job_ijIQidyFErmMaxO5AGuJuHWMAgA

It has been running since 10:30 GMT today and still running

The query is as follows:

SELECT a1, a2, b2, b1, a3, a4, INTEGER(b3), b4
FROM (SELECT a1, a2, MAX(a3) a3, MAX(a4) a4
      FROM TABLE_DATE_RANGE(t.a_, DATE_ADD(CURRENT_TIMESTAMP(), -30, 'DAY'),
                                           CURRENT_TIMESTAMP())
      WHERE a4 > 0
      GROUP BY a1, a2) a
JOIN EACH (SELECT b1, b2, MAX(b3) b3, MAX(b4) b4
           FROM TABLE_DATE_RANGE(t.b_, DATE_ADD(CURRENT_TIMESTAMP(), -30, 'DAY'),
                                                CURRENT_TIMESTAMP())
           WHERE INTEGER(b3) IN (0,2)
           GROUP BY b1, b2) b
ON a.a1 = b.b1 AND a.a2 = b.b2

This query runs everyday and was running perfectly until today where it doesn't returns the data or an error.

I tried to run a date where the query was successful (2015-07-10) and I get the same problem, continues running.

I'm running into a similar problem today. Query is part of a CRON job that ran yesterday without issue, but today isn't completing (stilling running after several hours). However, some of the other queries that ran in conjunction with this extended running query do finish in usual amount of time (30 secs). — stevenhancock

Jeremy Condit Jeremy Condit · Accepted Answer · 2015-08-13T07:31:19

We've rolled out some updates to our query engine which are intended to address intermittent slow queries. If you see this behavior again, please send us another job ID!

For suspected bugs, we recommend filing a bug here: http://code.google.com/p/google-bigquery/issues

Google BigQuery running forever

2 Answers