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_routines ⇒ Array<Google::Apis::BigqueryV2::RoutineReference>
[Output-only] Referenced routines (persistent user-defined functions and stored procedures) for the job.
-
#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
3056 3057 3058 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3056 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_routines ⇒ Array<Google::Apis::BigqueryV2::RoutineReference>
[Output-only] Referenced routines (persistent user-defined functions and
stored procedures) for the job.
Corresponds to the JSON property referencedRoutines
2976 2977 2978 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2976 def referenced_routines @referenced_routines 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
2982 2983 2984 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2982 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
2987 2988 2989 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2987 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
2993 2994 2995 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 2993 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
3013 3014 3015 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3013 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
3018 3019 3020 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3018 def timeline @timeline end |
#total_bytes_billed ⇒ Fixnum
[Output-only] Total bytes billed for the job.
Corresponds to the JSON property totalBytesBilled
3023 3024 3025 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3023 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
3028 3029 3030 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3028 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
3037 3038 3039 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3037 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
3043 3044 3045 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3043 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
3048 3049 3050 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3048 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
3054 3055 3056 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3054 def undeclared_query_parameters @undeclared_query_parameters end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 3061 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_routines = args[:referenced_routines] if args.key?(:referenced_routines) @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 |