com.google.cloud.bigquery

Class JobStatistics.QueryStatistics

java.lang.Object

com.google.cloud.bigquery.JobStatistics

com.google.cloud.bigquery.JobStatistics.QueryStatistics

All Implemented Interfaces:

Serializable

Enclosing class:

JobStatistics

public static class JobStatistics.QueryStatistics
extends JobStatistics

A Google BigQuery Query Job statistics.

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	JobStatistics.QueryStatistics.StatementType StatementType represents possible types of SQL statements reported as part of the QueryStatistics of a BigQuery job.

Nested classes/interfaces inherited from class com.google.cloud.bigquery.JobStatistics

JobStatistics.CopyStatistics, JobStatistics.ExtractStatistics, JobStatistics.LoadStatistics, JobStatistics.QueryStatistics, JobStatistics.ScriptStatistics

Method Summary

Modifier and Type	Method and Description
boolean	equals(Object obj)
Integer	getBillingTier() Returns the billing tier for the job.
Boolean	getCacheHit() Returns whether the query result was fetched from the query cache.
String	getDdlOperationPerformed() [BETA] For DDL queries, returns the operation applied to the DDL target table.
RoutineId	getDdlTargetRoutine() [BETA] For DDL queries, returns the RoutineId of the targeted routine.
TableId	getDdlTargetTable() [BETA] For DDL queries, returns the TableID of the targeted table.
Long	getEstimatedBytesProcessed() The original estimate of bytes processed for the job.
Long	getNumDmlAffectedRows() The number of rows affected by a DML statement.
List<QueryStage>	getQueryPlan() Returns the query plan as a list of stages or null if a query plan is not available.
List<TableId>	getReferencedTables() Referenced tables for the job.
Schema	getSchema() Returns the schema for the query result.
JobStatistics.QueryStatistics.StatementType	getStatementType() [BETA] The type of query statement, if valid.
List<TimelineSample>	getTimeline() Return the timeline for the query, as a list of timeline samples.
Long	getTotalBytesBilled() Returns the total number of bytes billed for the job.
Long	getTotalBytesProcessed() Returns the total number of bytes processed by the job.
Long	getTotalPartitionsProcessed() Total number of partitions processed from all partitioned tables referenced in the job.
Long	getTotalSlotMs() Returns the slot-milliseconds consumed by the query.
int	hashCode()

Methods inherited from class com.google.cloud.bigquery.JobStatistics

getCreationTime, getEndTime, getNumChildJobs, getParentJobId, getScriptStatistics, getStartTime, toString

Methods inherited from class java.lang.Object

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

Method Detail

getBillingTier

public Integer getBillingTier()

Returns the billing tier for the job.

getCacheHit

public Boolean getCacheHit()

Returns whether the query result was fetched from the query cache.

See Also:

Query Caching

getDdlOperationPerformed

public String getDdlOperationPerformed()

[BETA] For DDL queries, returns the operation applied to the DDL target table.

getDdlTargetTable

public TableId getDdlTargetTable()

[BETA] For DDL queries, returns the TableID of the targeted table.

getDdlTargetRoutine

public RoutineId getDdlTargetRoutine()

[BETA] For DDL queries, returns the RoutineId of the targeted routine.

getEstimatedBytesProcessed

public Long getEstimatedBytesProcessed()

The original estimate of bytes processed for the job.

getNumDmlAffectedRows

public Long getNumDmlAffectedRows()

The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.

getReferencedTables

public List<TableId> getReferencedTables()

Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.

getStatementType

public JobStatistics.QueryStatistics.StatementType getStatementType()

[BETA] The type of query statement, if valid. Possible values include: SELECT INSERT UPDATE DELETE CREATE_TABLE CREATE_TABLE_AS_SELECT DROP_TABLE CREATE_VIEW DROP_VIEW

getTotalBytesBilled

public Long getTotalBytesBilled()

Returns the total number of bytes billed for the job.

getTotalBytesProcessed

public Long getTotalBytesProcessed()

Returns the total number of bytes processed by the job.

getTotalPartitionsProcessed

public Long getTotalPartitionsProcessed()

Total number of partitions processed from all partitioned tables referenced in the job.

getTotalSlotMs

public Long getTotalSlotMs()

Returns the slot-milliseconds consumed by the query.

getQueryPlan

public List<QueryStage> getQueryPlan()

Returns the query plan as a list of stages or null if a query plan is not available. Each stage involves a number of steps that read from data sources, perform a series of transformations on the input, and emit an output to a future stage (or the final result). The query plan is available for a completed query job and is retained for 7 days.

See Also:

Query Plan

getTimeline

public List<TimelineSample> getTimeline()

Return the timeline for the query, as a list of timeline samples. Each sample provides information about the overall progress of the query. Information includes time of the sample, progress reporting on active, completed, and pending units of work, as well as the cumulative estimation of slot-milliseconds consumed by the query.

getSchema

public Schema getSchema()

Returns the schema for the query result. Present only for successful dry run of non-legacy SQL queries.

equals

public final boolean equals(Object obj)

Overrides:

equals in class Object

hashCode

public final int hashCode()

Overrides:

hashCode in class Object