6

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

enter image description here

Improve this question
4
  • Could you share the query or better a print screen. Commented Nov 11, 2014 at 11:47
  • @Pentium10 screenshot added Commented Nov 11, 2014 at 12:26
  • 1
    huh, you have 140 columns in your select? What's on line 6? Commented Nov 11, 2014 at 12:44
  • 1
    please copy paste the full query Commented Nov 11, 2014 at 13:52

1 Answer 1

Reset to default
3

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I am getting the same issue. I want to check all conditions from another table and if I use where clause then I have to write 100 ANDs. Please check query: SELECT fullVisitorId, hits.page.pagePath AS Page FROM (TABLE_DATE_RANGE([2535XXX.ga_sessions_], DATE_ADD(CURRENT_TIMESTAMP(), -10, 'DAY'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'))) WHERE hits.page.pagePath = ALL ( SELECT hits.page.pagePath FROM (TABLE_DATE_RANGE([2535XXZ.ga_sessions_], DATE_ADD(CURRENT_TIMESTAMP(), -10, 'DAY'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'))));

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.