Menu
I'm trying to run a query in the UI, but I get the error:
Error: 6.1 - 0.0: Only one query can be executed at a time.
I don't think there is any other queries running, and this has lasted for a while now. Surely it can handle more than one query at a time?? How long will this be stuck? How can I turn bigquery off and on again :p
649
You can use method 2 to chain the BigQuery queries. BigQuery’s query scheduler can be used to run the queries one after another. Idea is that we start the process the same as we did in method 1, i.e. trigger the first query using a scheduler and estimate its time for completion. Let’s say the first query takes 5 minutes to complete.
Query statements scan one or more tables or expressions and return the computed result rows. This topic describes the syntax for SQL queries in BigQuery.
In a value table, the row type is just a single value, and there are no column names. Note: In BigQuery, a query can only return a value table with a type of STRUCT. In contexts where a query with exactly one column is expected, a value table query can be used instead.
Note: The WITH clause is used primarily for readability because they are not materialized. If a query appears in more than one WITH clause, it executes in each clause. Learn how to query datasets in BigQuery using SQL, save and share queries, and create views and materialized views.
This error means that the query string has been parsed as containing multiple queries. Check that you do not have multiple top-level SELECT statements in the query text box.
From the specific message, I would guess your second query begins on or around line 6.
117
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
