Database Reference
In-Depth Information
Figure 4.6 Job states and errors
You can use the bq tool to inspect job state by using the show -j command.
The following code snippet creates a load job that will fail because the data
doesn't match the schema, and get the status of the job during each of the
three job phases.
$ JOB_ID=job_$(date +"%s")
$ bq --nosync -job_id=${JOB_ID} \
load scratch.table1 temp.csv "f1,f2"
Successfully started load bigquery-e2e:job_1394420275
$ bq show -j ${JOB_ID}
Job bigquery-e2e:job_1394420275
Job Type State Start Time Duration Bytes
Processed
---------- --------- ------------ ----------
-----------------
load PENDING
$ bq show -j ${JOB_ID}
Job bigquery-e2e:job_1394420275
Job Type State Start Time Duration
Bytes Processed
---------- --------- ----------------- ----------
-----------------
load RUNNING 21 Jul 15:32:14
$ bq show -j ${JOB_ID}
Job bigquery-e2e:job_1394420275
Job Type State Start Time Duration
Bytes Processed
---------- --------- ----------------- ----------
-----------------
load DONE 21 Jul 15:32:14 0:00:05
 
Search WWH ::




Custom Search