CODEWITHSUNDEEP
google-bigquery
Sasa
Sasa

Reputation: 301

BQ import succeeded despite SocketTimeoutException?

In some (rare) cases BQ import API call (GAE java) raises SocketTimeoutException. 

java.net.SocketTimeoutException: Timeout while fetching URL: https://www.googleapis.com/bigquery/v2/projects/{projectId}/jobs

Despite the exception it looks like data are successfully imported into BQ table. The problem is the "import" task is restarted (due to exception)-> causing duplicates.

Kind regards, sasa

Upvotes: 1

Views: 201

Answers (1)

Jordan Tigani
Jordan Tigani

Reputation: 26617

If you are worried about retrying an import that appeared to fail because of a network error, you can pass a job id along with the load job, in which case you'll be able to look up the status of the job before retrying.

Upvotes: 1

Related Questions