42649

In Google BigQuery API, what is the default timeout for a query response?

<h3>Question</h3>

In Google BigQuery API, what is the default timeout for a query response?

In other words, how long does it wait by default until the response returns null for an incomplete job.


<h3>Answer1:</h3>

The documentation for timeoutMs in the jobs.query says:

<blockquote>

[Optional] How long to wait for the query to complete, in milliseconds, before the request times out and returns. Note that this is only a timeout for the request, not the query. If the query takes longer to run than the timeout value, the call returns without any results and with the 'jobComplete' flag set to false. You can call GetQueryResults() to wait for the query to complete and read the results. The default value is 10000 milliseconds (10 seconds).

</blockquote>

If I understand correctly, though, I think you're asking how long a query can execute before timing out. We limit query execution to six hours (at the time of this writing), though I don't know if that's explicitly documented somewhere. In general, though, queries shouldn't take nearly that long to run.

If you want to impose a stricter timeout on query completion, you could use the jobs.cancel API after a specific amount of elapsed time, though note that you will still be charged for execution of the query.

来源:https://stackoverflow.com/questions/40160472/in-google-bigquery-api-what-is-the-default-timeout-for-a-query-response

Recommend

  • Javascript hasOwnProperty always false on Event objects?
  • Free implementation in scalaz
  • Standard behavior for direct initialization of unsigned short
  • Convert a program that uses includes to one using templates
  • show Custom Message at Table area in jqGrid
  • Read and Write UTF-8 characters from System.in stream
  • How to make a column editable on click Angular 4
  • Codes works jsfiddle not working on dreamweaver
  • EOFError Ran out of input Python
  • How to set current cell on SAP GUIContainerShell in C#?
  • Sequentially run commands in bash script
  • How to store confidential PDF documents (file system vs. SQL) if we only use forms authentication
  • How would I make a polygon based on the relative positions of markers in google maps?
  • Access VBA lookup folder and create if does not exist DLOOKUP
  • Getting nil from standardUserDefaults,
  • python: Using ncurses when underlying library logs to stdout
  • Putting multiple films in a circle in Raphael/Joint.js
  • Extract the data specified in brackets '[ ]' from a string message in python
  • Find a directory using wildcard in Inno Setup
  • Django IN query as a string result - invalid literal for int() with base 10
  • Set selected using jQuery
  • Change selectOneMenu stylesheet (Primefaces)
  • iOS - open another application that exists on the phone?
  • Detect when MathJax has finished loading in UIWebView
  • getting the values of checkboxes in a checkboxlist control
  • Python sum values in tuple in a list in a dictionary?
  • Expression.Call GroupBy then Select and Count()?
  • Bundling python(“.py”)files along with java class files for a web application
  • how to add dashed border on highcharts “area” graph for every point
  • Arraylist of strings into one comma separated string
  • Query takes almost two seconds but matches only two rows - why isn't the index helping?
  • How to make Rss News Reader application in android …? [closed]
  • Copy and paste data from multiple workbooks to a worksheet in another Workbook
  • Request Access Token in Postman for Azure Function App protected by Azure AD B2C
  • All Event listing on specified date in Google Calender api (V3) in java?
  • select an input by value?
  • Print Longitude and Latitude in textbox Android
  • iphone image to video issue in video speed
  • How to handle div that is created dynamically in a table
  • ReferenceError: TextEncoder is not defined