CODEWITHSUNDEEP
google-bigquery
user3690992
user3690992

Reputation: 41

Google BigQuery running forever

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.

Upvotes: 2

Views: 2036

Answers (2)

goidelg
goidelg

Reputation: 326

Try to the save the results to a destination table, and mark "allow large results" option under show options -> results size. For me, this usually solves such issues.

Upvotes: 0

Jeremy Condit
Jeremy Condit

Reputation: 7046

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

Upvotes: 1

Related Questions