Class: Google::Apis::BigqueryV2::JobStatistics2
- Inherits:
-
Object
- Object
- Google::Apis::BigqueryV2::JobStatistics2
- Includes:
- Core::Hashable, Core::JsonObjectSupport
- Defined in:
- generated/google/apis/bigquery_v2/classes.rb,
generated/google/apis/bigquery_v2/representations.rb,
generated/google/apis/bigquery_v2/representations.rb
Defined Under Namespace
Classes: ReservationUsage
Instance Attribute Summary collapse
-
#billing_tier ⇒ Fixnum
[Output-only] Billing tier for the job.
-
#cache_hit ⇒ Boolean
(also: #cache_hit?)
[Output-only] Whether the query result was fetched from the query cache.
-
#ddl_operation_performed ⇒ String
The DDL operation performed, possibly dependent on the pre-existence of the DDL target.
-
#ddl_target_routine ⇒ Google::Apis::BigqueryV2::RoutineReference
The DDL target routine.
-
#ddl_target_table ⇒ Google::Apis::BigqueryV2::TableReference
The DDL target table.
-
#estimated_bytes_processed ⇒ Fixnum
[Output-only] The original estimate of bytes processed for the job.
-
#model_training ⇒ Google::Apis::BigqueryV2::BigQueryModelTraining
[Output-only, Beta] Information about create model query job progress.
-
#model_training_current_iteration ⇒ Fixnum
[Output-only, Beta] Deprecated; do not use.
-
#model_training_expected_total_iteration ⇒ Fixnum
[Output-only, Beta] Deprecated; do not use.
-
#num_dml_affected_rows ⇒ Fixnum
[Output-only] The number of rows affected by a DML statement.
-
#query_plan ⇒ Array<Google::Apis::BigqueryV2::ExplainQueryStage>
[Output-only] Describes execution plan for the query.
-
#referenced_tables ⇒ Array<Google::Apis::BigqueryV2::TableReference>
[Output-only] Referenced tables for the job.
-
#reservation_usage ⇒ Array<Google::Apis::BigqueryV2::JobStatistics2::ReservationUsage>
[Output-only] Job resource usage breakdown by reservation.
-
#schema ⇒ Google::Apis::BigqueryV2::TableSchema
[Output-only] The schema of the results.
-
#statement_type ⇒ String
The type of query statement, if valid.
-
#timeline ⇒ Array<Google::Apis::BigqueryV2::QueryTimelineSample>
[Output-only] [Beta] Describes a timeline of job execution.
-
#total_bytes_billed ⇒ Fixnum
[Output-only] Total bytes billed for the job.
-
#total_bytes_processed ⇒ Fixnum
[Output-only] Total bytes processed for the job.
-
#total_bytes_processed_accuracy ⇒ String
[Output-only] For dry-run jobs, totalBytesProcessed is an estimate and this field specifies the accuracy of the estimate.
-
#total_partitions_processed ⇒ Fixnum
[Output-only] Total number of partitions processed from all partitioned tables referenced in the job.
-
#total_slot_ms ⇒ Fixnum
[Output-only] Slot-milliseconds for the job.
-
#undeclared_query_parameters ⇒ Array<Google::Apis::BigqueryV2::QueryParameter>
Standard SQL only: list of undeclared query parameters detected during a dry run validation.
Instance Method Summary collapse
-
#initialize(**args) ⇒ JobStatistics2
constructor
A new instance of JobStatistics2.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ JobStatistics2
Returns a new instance of JobStatistics2
3050 3051 3052 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3050 def initialize(**args) update!(**args) end |
Instance Attribute Details
#billing_tier ⇒ Fixnum
[Output-only] Billing tier for the job.
Corresponds to the JSON property billingTier
2911 2912 2913 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2911 def billing_tier @billing_tier end |
#cache_hit ⇒ Boolean Also known as: cache_hit?
[Output-only] Whether the query result was fetched from the query cache.
Corresponds to the JSON property cacheHit
2916 2917 2918 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2916 def cache_hit @cache_hit end |
#ddl_operation_performed ⇒ String
The DDL operation performed, possibly dependent on the pre-existence of the
DDL target. Possible values (new values might be added in the future): "CREATE"
: The query created the DDL target. "SKIP": No-op. Example cases: the query is
CREATE TABLE IF NOT EXISTS while the table already exists, or the query is
DROP TABLE IF EXISTS while the table does not exist. "REPLACE": The query
replaced the DDL target. Example case: the query is CREATE OR REPLACE TABLE,
and the table already exists. "DROP": The query deleted the DDL target.
Corresponds to the JSON property ddlOperationPerformed
2928 2929 2930 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2928 def ddl_operation_performed @ddl_operation_performed end |
#ddl_target_routine ⇒ Google::Apis::BigqueryV2::RoutineReference
The DDL target routine. Present only for CREATE/DROP FUNCTION/PROCEDURE
queries.
Corresponds to the JSON property ddlTargetRoutine
2934 2935 2936 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2934 def ddl_target_routine @ddl_target_routine end |
#ddl_target_table ⇒ Google::Apis::BigqueryV2::TableReference
The DDL target table. Present only for CREATE/DROP TABLE/VIEW queries.
Corresponds to the JSON property ddlTargetTable
2939 2940 2941 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2939 def ddl_target_table @ddl_target_table end |
#estimated_bytes_processed ⇒ Fixnum
[Output-only] The original estimate of bytes processed for the job.
Corresponds to the JSON property estimatedBytesProcessed
2944 2945 2946 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2944 def estimated_bytes_processed @estimated_bytes_processed end |
#model_training ⇒ Google::Apis::BigqueryV2::BigQueryModelTraining
[Output-only, Beta] Information about create model query job progress.
Corresponds to the JSON property modelTraining
2949 2950 2951 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2949 def model_training @model_training end |
#model_training_current_iteration ⇒ Fixnum
[Output-only, Beta] Deprecated; do not use.
Corresponds to the JSON property modelTrainingCurrentIteration
2954 2955 2956 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2954 def model_training_current_iteration @model_training_current_iteration end |
#model_training_expected_total_iteration ⇒ Fixnum
[Output-only, Beta] Deprecated; do not use.
Corresponds to the JSON property modelTrainingExpectedTotalIteration
2959 2960 2961 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2959 def model_training_expected_total_iteration @model_training_expected_total_iteration end |
#num_dml_affected_rows ⇒ Fixnum
[Output-only] The number of rows affected by a DML statement. Present only for
DML statements INSERT, UPDATE or DELETE.
Corresponds to the JSON property numDmlAffectedRows
2965 2966 2967 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2965 def num_dml_affected_rows @num_dml_affected_rows end |
#query_plan ⇒ Array<Google::Apis::BigqueryV2::ExplainQueryStage>
[Output-only] Describes execution plan for the query.
Corresponds to the JSON property queryPlan
2970 2971 2972 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2970 def query_plan @query_plan end |
#referenced_tables ⇒ Array<Google::Apis::BigqueryV2::TableReference>
[Output-only] Referenced tables for the job. Queries that reference more than
50 tables will not have a complete list.
Corresponds to the JSON property referencedTables
2976 2977 2978 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2976 def referenced_tables @referenced_tables end |
#reservation_usage ⇒ Array<Google::Apis::BigqueryV2::JobStatistics2::ReservationUsage>
[Output-only] Job resource usage breakdown by reservation.
Corresponds to the JSON property reservationUsage
2981 2982 2983 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2981 def reservation_usage @reservation_usage end |
#schema ⇒ Google::Apis::BigqueryV2::TableSchema
[Output-only] The schema of the results. Present only for successful dry run
of non-legacy SQL queries.
Corresponds to the JSON property schema
2987 2988 2989 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2987 def schema @schema end |
#statement_type ⇒ String
The type of query statement, if valid. Possible values (new values might be
added in the future): "SELECT": SELECT query. "INSERT": INSERT query; see
https://cloud.google.com/bigquery/docs/reference/standard-sql/data-
manipulation-language. "UPDATE": UPDATE query; see https://cloud.google.com/
bigquery/docs/reference/standard-sql/data-manipulation-language. "DELETE":
DELETE query; see https://cloud.google.com/bigquery/docs/reference/standard-
sql/data-manipulation-language. "MERGE": MERGE query; see https://cloud.google.
com/bigquery/docs/reference/standard-sql/data-manipulation-language. "
ALTER_TABLE": ALTER TABLE query. "ALTER_VIEW": ALTER VIEW query. "
CREATE_FUNCTION": CREATE FUNCTION query. "CREATE_MODEL": CREATE [OR REPLACE]
MODEL ... AS SELECT ... . "CREATE_PROCEDURE": CREATE PROCEDURE query. "
CREATE_TABLE": CREATE [OR REPLACE] TABLE without AS SELECT. "
CREATE_TABLE_AS_SELECT": CREATE [OR REPLACE] TABLE ... AS SELECT ... . "
CREATE_VIEW": CREATE [OR REPLACE] VIEW ... AS SELECT ... . "DROP_FUNCTION" :
DROP FUNCTION query. "DROP_PROCEDURE": DROP PROCEDURE query. "DROP_TABLE":
DROP TABLE query. "DROP_VIEW": DROP VIEW query.
Corresponds to the JSON property statementType
3007 3008 3009 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3007 def statement_type @statement_type end |
#timeline ⇒ Array<Google::Apis::BigqueryV2::QueryTimelineSample>
[Output-only] [Beta] Describes a timeline of job execution.
Corresponds to the JSON property timeline
3012 3013 3014 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3012 def timeline @timeline end |
#total_bytes_billed ⇒ Fixnum
[Output-only] Total bytes billed for the job.
Corresponds to the JSON property totalBytesBilled
3017 3018 3019 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3017 def total_bytes_billed @total_bytes_billed end |
#total_bytes_processed ⇒ Fixnum
[Output-only] Total bytes processed for the job.
Corresponds to the JSON property totalBytesProcessed
3022 3023 3024 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3022 def total_bytes_processed @total_bytes_processed end |
#total_bytes_processed_accuracy ⇒ String
[Output-only] For dry-run jobs, totalBytesProcessed is an estimate and this
field specifies the accuracy of the estimate. Possible values can be: UNKNOWN:
accuracy of the estimate is unknown. PRECISE: estimate is precise. LOWER_BOUND:
estimate is lower bound of what the query would cost. UPPER_BOUND: estimate
is upper bound of what the query would cost.
Corresponds to the JSON property totalBytesProcessedAccuracy
3031 3032 3033 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3031 def total_bytes_processed_accuracy @total_bytes_processed_accuracy end |
#total_partitions_processed ⇒ Fixnum
[Output-only] Total number of partitions processed from all partitioned tables
referenced in the job.
Corresponds to the JSON property totalPartitionsProcessed
3037 3038 3039 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3037 def total_partitions_processed @total_partitions_processed end |
#total_slot_ms ⇒ Fixnum
[Output-only] Slot-milliseconds for the job.
Corresponds to the JSON property totalSlotMs
3042 3043 3044 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3042 def total_slot_ms @total_slot_ms end |
#undeclared_query_parameters ⇒ Array<Google::Apis::BigqueryV2::QueryParameter>
Standard SQL only: list of undeclared query parameters detected during a dry
run validation.
Corresponds to the JSON property undeclaredQueryParameters
3048 3049 3050 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3048 def undeclared_query_parameters @undeclared_query_parameters end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3055 def update!(**args) @billing_tier = args[:billing_tier] if args.key?(:billing_tier) @cache_hit = args[:cache_hit] if args.key?(:cache_hit) @ddl_operation_performed = args[:ddl_operation_performed] if args.key?(:ddl_operation_performed) @ddl_target_routine = args[:ddl_target_routine] if args.key?(:ddl_target_routine) @ddl_target_table = args[:ddl_target_table] if args.key?(:ddl_target_table) @estimated_bytes_processed = args[:estimated_bytes_processed] if args.key?(:estimated_bytes_processed) @model_training = args[:model_training] if args.key?(:model_training) @model_training_current_iteration = args[:model_training_current_iteration] if args.key?(:model_training_current_iteration) @model_training_expected_total_iteration = args[:model_training_expected_total_iteration] if args.key?(:model_training_expected_total_iteration) @num_dml_affected_rows = args[:num_dml_affected_rows] if args.key?(:num_dml_affected_rows) @query_plan = args[:query_plan] if args.key?(:query_plan) @referenced_tables = args[:referenced_tables] if args.key?(:referenced_tables) @reservation_usage = args[:reservation_usage] if args.key?(:reservation_usage) @schema = args[:schema] if args.key?(:schema) @statement_type = args[:statement_type] if args.key?(:statement_type) @timeline = args[:timeline] if args.key?(:timeline) @total_bytes_billed = args[:total_bytes_billed] if args.key?(:total_bytes_billed) @total_bytes_processed = args[:total_bytes_processed] if args.key?(:total_bytes_processed) @total_bytes_processed_accuracy = args[:total_bytes_processed_accuracy] if args.key?(:total_bytes_processed_accuracy) @total_partitions_processed = args[:total_partitions_processed] if args.key?(:total_partitions_processed) @total_slot_ms = args[:total_slot_ms] if args.key?(:total_slot_ms) @undeclared_query_parameters = args[:undeclared_query_parameters] if args.key?(:undeclared_query_parameters) end |