Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Queriying on table with large data gives null response the first time

Hi,

I am developing an integrating with Google big query, I have notices sometimes "/queries" API endpoint responds with "jobComplete"false when ever queries on table with huge data, and when hit again then it responds with the desired table data and jobComplete as true. I wanted to know what is the maximum time that GBQ takes to fetch huge data rather complete a "select" job, as we are trying to implement retry mechanism and we can only retry for couple of times within a  restricted time range.

Need suggestion here, if the time to complete the job is more then what should be done so that we can get the data in the first hit only.

 

0 1 153
1 REPLY 1