Geek asks and answers

How to stop the request from starting

Is there a way to cancel a running request?

I am using the web interface. I first ran a series of tests on tables 10k and 20k rows, and the answer was in seconds. but how did I run the query for a triple join on a table of 100 thousand rows and it seems to be infinite after a thousand seconds.

I just needed to run some tests before transferring all the work to bigquery, but now I'm afraid that he will spend the whole monthly 100GB of free limit + more.

a table is a simple key-value pair of integer values.

+5
source share
3 answers

bq cancel job_id . job_id " " BigQuery. CLI, job_id .

+6

API . , ( "x" ) , . .

, , , , , , - . :

SELECT t1.foo 
FROM (SELECT 1 as one, foo FROM table1) t1 
JOIN (SELECT 1 as one, bar FROM table2) t2
ON t1.one = t2.one

n x m , n - 1, m - 2. , - ? , ? (, SO, ).

+3

We did not find a way to stop working using the Java API, and as far as I know, you cannot stop working in the web interface.

+1
source

More articles:


All Articles