com.google.api.services.bigquery.model

Class JobConfigurationQuery

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.JobConfigurationQuery

All Implemented Interfaces:

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

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

Model definition for JobConfigurationQuery.

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
JobConfigurationQuery()

Method Summary

Methods

Modifier and Type	Method and Description
JobConfigurationQuery	clone()
java.lang.Boolean	getAllowLargeResults() If true, allows the query to produce arbitrarily large result tables at a slight cost in performance.
java.lang.String	getCreateDisposition() [Optional] Specifies whether the job is allowed to create new tables.
DatasetReference	getDefaultDataset() [Optional] Specifies the default dataset to use for unqualified table names in the query.
TableReference	getDestinationTable() [Optional] Describes the table where the query results should be stored.
java.lang.Boolean	getFlattenResults() [Optional] Flattens all nested and repeated fields in the query results.
java.lang.Integer	getMaximumBillingTier() [Optional] Limits the billing tier for this job.
java.lang.Boolean	getPreserveNulls() [Deprecated] This property is deprecated.
java.lang.String	getPriority() [Optional] Specifies a priority for the query.
java.lang.String	getQuery() [Required] BigQuery SQL query to execute.
java.util.Map<java.lang.String,ExternalDataConfiguration>	getTableDefinitions() [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source.
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.
java.util.List<UserDefinedFunctionResource>	getUserDefinedFunctionResources() [Experimental] Describes user-defined function resources used in the query.
java.lang.String	getWriteDisposition() [Optional] Specifies the action that occurs if the destination table already exists.
boolean	isFlattenResults() Convenience method that returns only Boolean.TRUE or Boolean.FALSE.
boolean	isUseQueryCache() Convenience method that returns only Boolean.TRUE or Boolean.FALSE.
JobConfigurationQuery	set(java.lang.String fieldName, java.lang.Object value)
JobConfigurationQuery	setAllowLargeResults(java.lang.Boolean allowLargeResults) If true, allows the query to produce arbitrarily large result tables at a slight cost in performance.
JobConfigurationQuery	setCreateDisposition(java.lang.String createDisposition) [Optional] Specifies whether the job is allowed to create new tables.
JobConfigurationQuery	setDefaultDataset(DatasetReference defaultDataset) [Optional] Specifies the default dataset to use for unqualified table names in the query.
JobConfigurationQuery	setDestinationTable(TableReference destinationTable) [Optional] Describes the table where the query results should be stored.
JobConfigurationQuery	setFlattenResults(java.lang.Boolean flattenResults) [Optional] Flattens all nested and repeated fields in the query results.
JobConfigurationQuery	setMaximumBillingTier(java.lang.Integer maximumBillingTier) [Optional] Limits the billing tier for this job.
JobConfigurationQuery	setPreserveNulls(java.lang.Boolean preserveNulls) [Deprecated] This property is deprecated.
JobConfigurationQuery	setPriority(java.lang.String priority) [Optional] Specifies a priority for the query.
JobConfigurationQuery	setQuery(java.lang.String query) [Required] BigQuery SQL query to execute.
JobConfigurationQuery	setTableDefinitions(java.util.Map<java.lang.String,ExternalDataConfiguration> tableDefinitions) [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source.
JobConfigurationQuery	setUseLegacySql(java.lang.Boolean useLegacySql) [Experimental] Specifies whether to use BigQuery's legacy SQL dialect for this query.
JobConfigurationQuery	setUseQueryCache(java.lang.Boolean useQueryCache) [Optional] Whether to look for the result in the query cache.
JobConfigurationQuery	setUserDefinedFunctionResources(java.util.List<UserDefinedFunctionResource> userDefinedFunctionResources) [Experimental] Describes user-defined function resources used in the query.
JobConfigurationQuery	setWriteDisposition(java.lang.String writeDisposition) [Optional] Specifies the action that occurs if the destination table already exists.

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

JobConfigurationQuery

public JobConfigurationQuery()

Method Detail

getAllowLargeResults

public java.lang.Boolean getAllowLargeResults()

If true, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set.

Returns:

value or null for none

setAllowLargeResults

public JobConfigurationQuery setAllowLargeResults(java.lang.Boolean allowLargeResults)

If true, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set.

Parameters:

allowLargeResults - allowLargeResults or null for none

getCreateDisposition

public java.lang.String getCreateDisposition()

[Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.

Returns:

value or null for none

setCreateDisposition

public JobConfigurationQuery setCreateDisposition(java.lang.String createDisposition)

[Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.

Parameters:

createDisposition - createDisposition or null for none

getDefaultDataset

public DatasetReference getDefaultDataset()

[Optional] Specifies the default dataset to use for unqualified table names in the query.

Returns:

value or null for none

setDefaultDataset

public JobConfigurationQuery setDefaultDataset(DatasetReference defaultDataset)

[Optional] Specifies the default dataset to use for unqualified table names in the query.

Parameters:

defaultDataset - defaultDataset or null for none

getDestinationTable

public TableReference getDestinationTable()

[Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.

Returns:

value or null for none

setDestinationTable

public JobConfigurationQuery setDestinationTable(TableReference destinationTable)

[Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.

Parameters:

destinationTable - destinationTable or null for none

getFlattenResults

public java.lang.Boolean getFlattenResults()

[Optional] Flattens all nested and repeated fields in the query results. The default value is true. allowLargeResults must be true if this is set to false.

Returns:

value or null for none

setFlattenResults

public JobConfigurationQuery setFlattenResults(java.lang.Boolean flattenResults)

[Optional] Flattens all nested and repeated fields in the query results. The default value is true. allowLargeResults must be true if this is set to false.

Parameters:

flattenResults - flattenResults or null for none

isFlattenResults

public boolean isFlattenResults()

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] Flattens all nested and repeated fields in the query results. The default value is true. [ allowLargeResults must be true if this is set to false.

getMaximumBillingTier

public java.lang.Integer getMaximumBillingTier()

[Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.

Returns:

value or null for none

setMaximumBillingTier

public JobConfigurationQuery setMaximumBillingTier(java.lang.Integer maximumBillingTier)

[Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.

Parameters:

maximumBillingTier - maximumBillingTier or null for none

getPreserveNulls

public java.lang.Boolean getPreserveNulls()

[Deprecated] This property is deprecated.

Returns:

value or null for none

setPreserveNulls

public JobConfigurationQuery setPreserveNulls(java.lang.Boolean preserveNulls)

[Deprecated] This property is deprecated.

Parameters:

preserveNulls - preserveNulls or null for none

getPriority

public java.lang.String getPriority()

[Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.

Returns:

value or null for none

setPriority

public JobConfigurationQuery setPriority(java.lang.String priority)

[Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.

Parameters:

priority - priority or null for none

getQuery

public java.lang.String getQuery()

[Required] BigQuery SQL query to execute.

Returns:

value or null for none

setQuery

public JobConfigurationQuery setQuery(java.lang.String query)

[Required] BigQuery SQL query to execute.

Parameters:

query - query or null for none

getTableDefinitions

public java.util.Map<java.lang.String,ExternalDataConfiguration> getTableDefinitions()

[Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.

Returns:

value or null for none

setTableDefinitions

public JobConfigurationQuery setTableDefinitions(java.util.Map<java.lang.String,ExternalDataConfiguration> tableDefinitions)

[Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.

Parameters:

tableDefinitions - tableDefinitions 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 standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the values of allowLargeResults and flattenResults are ignored; query will be run as if allowLargeResults is true and flattenResults is false.

Returns:

value or null for none

setUseLegacySql

public JobConfigurationQuery 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 standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the values of allowLargeResults and flattenResults are ignored; query 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. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.

Returns:

value or null for none

setUseQueryCache

public JobConfigurationQuery 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. Moreover, the query cache is only available when a query does not have a destination table specified. 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. Moreover, the query cache is [ only available when a query does not have a destination table specified. The default value is [ true.

getUserDefinedFunctionResources

public java.util.List<UserDefinedFunctionResource> getUserDefinedFunctionResources()

[Experimental] Describes user-defined function resources used in the query.

Returns:

value or null for none

setUserDefinedFunctionResources

public JobConfigurationQuery setUserDefinedFunctionResources(java.util.List<UserDefinedFunctionResource> userDefinedFunctionResources)

[Experimental] Describes user-defined function resources used in the query.

Parameters:

userDefinedFunctionResources - userDefinedFunctionResources or null for none

getWriteDisposition

public java.lang.String getWriteDisposition()

[Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.

Returns:

value or null for none

setWriteDisposition

public JobConfigurationQuery setWriteDisposition(java.lang.String writeDisposition)

[Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.

Parameters:

writeDisposition - writeDisposition or null for none

set

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

Overrides:

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

clone

public JobConfigurationQuery clone()

Overrides:

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