BigQuery unexpected error

2
votes

Running very simple queries against my table and getting unexpected errors. Anybody from the BQ engineering team able to look at my Job IDs and figure out what's happening here?

SELECT field from mydataset.mytable
limit 100

Error: Unexpected. Please try again.
Job ID: natural-terra-531:job_OhD8zgm8btXQPNuwGSdIMoDX_f4

Another one with aggregation:

SELECT city, max(timestamp) from mydataset.mytable
GROUP BY city limit 100

Error: Unexpected. Please try again.
Job ID: natural-terra-531:job_9DjzAgn05yKZSYKCANHNbckE4f8
1
google-bigquery

1 Answers

0
votes

The BigQuery service had a temporary glitch last night that caused a high rate of failure for some queries between 10 and 10:30 PM due to a misconfiguration. We're conducting a postmortem to make sure we can prevent it in the future. If you retry the queries, they should work. If they do not, please let us know.