BigQuery : An internal error occurred and the request could not be completed

Question

Simple select queries with timestamp are failing :

SELECT COUNT(*) FROM [bi.table] WHERE  timestamp > DATE_ADD(CURRENT_TIMESTAMP(), -15, 'MINUTE') and column1 is null

Query Failed:

Error: An internal error occurred and the request could not be completed. Job ID: exampleJob:job_lndEirUwwM_khdBrV8eMDmBDFiE   

Is there anything wrong with the bigquery system?

https://status.cloud.google.com/ does not say anything is wrong.

Answer 1

This error was actually unrelated to the timestamps. You hit an error in our streaming ingestion service. It was overloaded at the time you ran your query and it could not serve the data that had been ingested for your table. We are investigating and will fix the underlying issue. Sorry for the inconvenience.