Geek Answers Handbook

BigQuery: unable to delete table

We have a large table (several large and 15 million rows), which we fill with testing for stress and stability. We are trying to delete the table, but it is resisting.

Here is what we tried:

  • Delete a table from the web console. There are no errors ... but it does not delete the table.

  • remove from the command line interface. Error message appears: "BigQuery error in rm operation: Backend error"

  • We also tried to delete the entire dataset from the console, and this also fails. No errors reported.

  • We tried to remove the entire dataset from the command line. We get the same error message: "BigQuery error rm: Backend error"

Other tables with the same schema can be deleted without errors. Our scheme uses 9999 columns (maximum), which would be the only weird thing we can do.

+4
source share
1 answer

You are in error with tables with lots of updates and a wide schema. We are working on a fix.

+1
source

More articles:


All Articles