Package 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:

  • Method Details

    • getBiEngineStats

      public BiEngineStats getBiEngineStats()
      Returns query statistics specific to the use of BI Engine.

    • 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:

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

    • getDmlStats

      public DmlStats getDmlStats()
      Detailed statistics for DML statements.

    • 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:

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

    • getSearchStats

      public SearchStats getSearchStats()
      Statistics for a search query. Populated as part of JobStatistics2. Provides information about how indexes are used in search queries. If an index is not used, you can retrieve debugging information about the reason why.

    • getQueryParameters

      public List<com.google.api.services.bigquery.model.QueryParameter> getQueryParameters()
      Standard SQL only: Returns a list of undeclared query parameters detected during a dry run validation.

    • equals

      public final boolean equals(Object obj)
      Overrides:
      equals in class Object

    • hashCode

      public final int hashCode()
      Overrides:
      hashCode in class Object