com.google.api.services.bigquery.model

Class QueryRequest

java.lang.Object

java.util.AbstractMap<java.lang.String,java.lang.Object>

com.google.api.client.util.GenericData

com.google.api.client.json.GenericJson

com.google.api.services.bigquery.model.QueryRequest

All Implemented Interfaces:

java.lang.Cloneable, java.util.Map<java.lang.String,java.lang.Object>

public final class QueryRequest
extends com.google.api.client.json.GenericJson

Model definition for QueryRequest.

This is the Java data model class that specifies how to parse/serialize into the JSON that is transmitted over HTTP when working with the BigQuery API. For a detailed explanation see: https://developers.google.com/api-client-library/java/google-http-java-client/json

Author:

Google, Inc.

Nested Class Summary

Nested classes/interfaces inherited from class com.google.api.client.util.GenericData

com.google.api.client.util.GenericData.Flags

Nested classes/interfaces inherited from class java.util.AbstractMap

java.util.AbstractMap.SimpleEntry<K,V>, java.util.AbstractMap.SimpleImmutableEntry<K,V>

Nested classes/interfaces inherited from interface java.util.Map

java.util.Map.Entry<K,V>

Constructor Summary

Constructors

Constructor and Description
QueryRequest()

Method Summary

Methods

Modifier and Type	Method and Description
QueryRequest	clone()
DatasetReference	getDefaultDataset() [Optional] Specifies the default datasetId and projectId to assume for any unqualified table names in the query.
java.lang.Boolean	getDryRun() [Optional] If set to true, BigQuery doesn't run the job.
java.lang.String	getKind() The resource type of the request.
java.lang.Long	getMaxResults() [Optional] The maximum number of rows of data to return per page of results.
java.lang.Boolean	getPreserveNulls() [Deprecated] This property is deprecated.
java.lang.String	getQuery() [Required] A query string, following the BigQuery query syntax, of the query to execute.
java.lang.Long	getTimeoutMs() [Optional] How long to wait for the query to complete, in milliseconds, before the request times out and returns.
java.lang.Boolean	getUseLegacySql() [Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query.
java.lang.Boolean	getUseQueryCache() [Optional] Whether to look for the result in the query cache.
boolean	isUseQueryCache() Convenience method that returns only Boolean.TRUE or Boolean.FALSE.
QueryRequest	set(java.lang.String fieldName, java.lang.Object value)
QueryRequest	setDefaultDataset(DatasetReference defaultDataset) [Optional] Specifies the default datasetId and projectId to assume for any unqualified table names in the query.
QueryRequest	setDryRun(java.lang.Boolean dryRun) [Optional] If set to true, BigQuery doesn't run the job.
QueryRequest	setKind(java.lang.String kind) The resource type of the request.
QueryRequest	setMaxResults(java.lang.Long maxResults) [Optional] The maximum number of rows of data to return per page of results.
QueryRequest	setPreserveNulls(java.lang.Boolean preserveNulls) [Deprecated] This property is deprecated.
QueryRequest	setQuery(java.lang.String query) [Required] A query string, following the BigQuery query syntax, of the query to execute.
QueryRequest	setTimeoutMs(java.lang.Long timeoutMs) [Optional] How long to wait for the query to complete, in milliseconds, before the request times out and returns.
QueryRequest	setUseLegacySql(java.lang.Boolean useLegacySql) [Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query.
QueryRequest	setUseQueryCache(java.lang.Boolean useQueryCache) [Optional] Whether to look for the result in the query cache.

Methods inherited from class com.google.api.client.json.GenericJson

getFactory, setFactory, toPrettyString, toString

Methods inherited from class com.google.api.client.util.GenericData

entrySet, get, getClassInfo, getUnknownKeys, put, putAll, remove, setUnknownKeys

Methods inherited from class java.util.AbstractMap

clear, containsKey, containsValue, equals, hashCode, isEmpty, keySet, size, values

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

QueryRequest

public QueryRequest()

Method Detail

getDefaultDataset

public DatasetReference getDefaultDataset()

[Optional] Specifies the default datasetId and projectId to assume for any unqualified table names in the query. If not set, all table names in the query string must be qualified in the format 'datasetId.tableId'.

Returns:

value or null for none

setDefaultDataset

public QueryRequest setDefaultDataset(DatasetReference defaultDataset)

[Optional] Specifies the default datasetId and projectId to assume for any unqualified table names in the query. If not set, all table names in the query string must be qualified in the format 'datasetId.tableId'.

Parameters:

defaultDataset - defaultDataset or null for none

getDryRun

public java.lang.Boolean getDryRun()

[Optional] If set to true, BigQuery doesn't run the job. Instead, if the query is valid, BigQuery returns statistics about the job such as how many bytes would be processed. If the query is invalid, an error returns. The default value is false.

Returns:

value or null for none

setDryRun

public QueryRequest setDryRun(java.lang.Boolean dryRun)

[Optional] If set to true, BigQuery doesn't run the job. Instead, if the query is valid, BigQuery returns statistics about the job such as how many bytes would be processed. If the query is invalid, an error returns. The default value is false.

Parameters:

dryRun - dryRun or null for none

getKind

public java.lang.String getKind()

The resource type of the request.

Returns:

value or null for none

setKind

public QueryRequest setKind(java.lang.String kind)

The resource type of the request.

Parameters:

kind - kind or null for none

getMaxResults

public java.lang.Long getMaxResults()

[Optional] The maximum number of rows of data to return per page of results. Setting this flag to a small value such as 1000 and then paging through results might improve reliability when the query result set is large. In addition to this limit, responses are also limited to 10 MB. By default, there is no maximum row count, and only the byte limit applies.

Returns:

value or null for none

setMaxResults

public QueryRequest setMaxResults(java.lang.Long maxResults)

[Optional] The maximum number of rows of data to return per page of results. Setting this flag to a small value such as 1000 and then paging through results might improve reliability when the query result set is large. In addition to this limit, responses are also limited to 10 MB. By default, there is no maximum row count, and only the byte limit applies.

Parameters:

maxResults - maxResults or null for none

getPreserveNulls

public java.lang.Boolean getPreserveNulls()

[Deprecated] This property is deprecated.

Returns:

value or null for none

setPreserveNulls

public QueryRequest setPreserveNulls(java.lang.Boolean preserveNulls)

[Deprecated] This property is deprecated.

Parameters:

preserveNulls - preserveNulls or null for none

getQuery

public java.lang.String getQuery()

[Required] A query string, following the BigQuery query syntax, of the query to execute. Example: "SELECT count(f1) FROM [myProjectId:myDatasetId.myTableId]".

Returns:

value or null for none

setQuery

public QueryRequest setQuery(java.lang.String query)

[Required] A query string, following the BigQuery query syntax, of the query to execute. Example: "SELECT count(f1) FROM [myProjectId:myDatasetId.myTableId]".

Parameters:

query - query or null for none

getTimeoutMs

public java.lang.Long getTimeoutMs()

[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).

Returns:

value or null for none

setTimeoutMs

public QueryRequest setTimeoutMs(java.lang.Long timeoutMs)

[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).

Parameters:

timeoutMs - timeoutMs or null for none

getUseLegacySql

public java.lang.Boolean getUseLegacySql()

[Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's updated SQL dialect with improved standards compliance: https://cloud.google.com/bigquery/sql-reference/ When using BigQuery's updated SQL, the values of allowLargeResults and flattenResults are ignored. Queries with useLegacySql set to false will be run as if allowLargeResults is true and flattenResults is false.

Returns:

value or null for none

setUseLegacySql

public QueryRequest setUseLegacySql(java.lang.Boolean useLegacySql)

[Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's updated SQL dialect with improved standards compliance: https://cloud.google.com/bigquery/sql-reference/ When using BigQuery's updated SQL, the values of allowLargeResults and flattenResults are ignored. Queries with useLegacySql set to false will be run as if allowLargeResults is true and flattenResults is false.

Parameters:

useLegacySql - useLegacySql or null for none

getUseQueryCache

public java.lang.Boolean getUseQueryCache()

[Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. The default value is true.

Returns:

value or null for none

setUseQueryCache

public QueryRequest setUseQueryCache(java.lang.Boolean useQueryCache)

[Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. The default value is true.

Parameters:

useQueryCache - useQueryCache or null for none

isUseQueryCache

public boolean isUseQueryCache()

Convenience method that returns only Boolean.TRUE or Boolean.FALSE.

Boolean properties can have four possible values: null, Data.NULL_BOOLEAN, Boolean.TRUE or Boolean.FALSE.

This method returns Boolean.TRUE if the default of the property is Boolean.TRUE and it is null or Data.NULL_BOOLEAN. Boolean.FALSE is returned if the default of the property is Boolean.FALSE and it is null or Data.NULL_BOOLEAN.

[ Optional] Whether to look for the result in the query cache. The query cache is a best-effort [ cache that will be flushed whenever tables in the query are modified. The default value is true.

set

public QueryRequest set(java.lang.String fieldName,
               java.lang.Object value)

Overrides:

set in class com.google.api.client.json.GenericJson

clone

public QueryRequest clone()

Overrides:

clone in class com.google.api.client.json.GenericJson