BigQuery slow on simple query

Question

Lately I've noticed that BigQuery is slow on a simple query, single table, without joins. It takes a minute and more to execute the following query on a table with 9000 rows:

SELECT 
 max(repeatedElement1) as elem1, 
 max(repeatedElement2) as elem2, 
 max(repeatedElement3) as elem3, 
FROM myTable 
WHERE id = '543978b4e4b09bccb70c7473'

Exact query is 507322187707:job_rDMpbbAUjpsGsv-jTxaVJU-gRRg

IIRC, this used to take much less time to execute.

The only page that I know of right now is the bigquery-downtime-notify page. Other than that, I watch on Stackoverflow if other have a similar problem. I also watch the BigQuery issues page where users can report bugs. — Pentium10

Jordan Tigani Jordan Tigani · Accepted Answer · 2014-10-13T16:32:53

I looked at the logs for your query, and it looks like you're hitting a performance bug in bigquery (we're taking far too long before actually starting the query). We've fixed this (and several other performance issues) in the next release, which will hopefully go out on wednesday of this week, but may be later than that if we find regressions.

I'll try to remember to update this thread with the status, but if I don't, feel free to ping me.

BigQuery slow on simple query

1 Answers