See
<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/146/display/redirect>
Changes:
------------------------------------------
[...truncated 488.72 KB...]
INFO: 2023-03-17T10:58:14.773Z: Fusing consumer
BeamCalcRel_189/ParMultiDo(Calc) into BeamIOSourceRel_99/ParDo(RowMonitor)
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:14.805Z: Fusing consumer ParDo(TimeMonitor) into
BeamCalcRel_189/ParMultiDo(Calc)
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:14.835Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup into BeamIOSourceRel_99/Read Input
BQ Rows/PassThroughThenCleanup/Create(CleanupOperation)/Read(CreateSource)
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:14.871Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map
into BeamIOSourceRel_99/Read Input BQ Rows/TriggerIdCreation/Read(CreateSource)
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:14.904Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:14.931Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:14.951Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Write
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:14.983Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Read
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.014Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.038Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.065Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.090Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Write
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.123Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/ParDo(IsmRecordForSingularValuePerWindow)
into BeamIOSourceRel_99/Read Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Read
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.472Z: Executing operation BeamIOSourceRel_99/Read
Input BQ Rows/Read(BigQueryTableSource)+BeamIOSourceRel_99/Read Input BQ
Rows/PassThroughThenCleanup/ParMultiDo(Identity)+BeamIOSourceRel_99/ParDo(RowMonitor)+BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/View.AsIterable/ParDo(ToIsmRecordForGlobalWindow)+BeamCalcRel_189/ParMultiDo(Calc)+ParDo(TimeMonitor)
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.504Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Create
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.550Z: Starting 5 workers in us-central1-b...
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:15.973Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Create
Mar 17, 2023 10:58:17 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:16.115Z: Executing operation BeamIOSourceRel_99/Read
Input BQ Rows/TriggerIdCreation/Read(CreateSource)+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Write
Mar 17, 2023 10:58:39 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:38.655Z: Your project already contains 100
Dataflow-created metric descriptors, so new user metrics of the form
custom.googleapis.com/* will not be created. However, all user metrics are also
available in the metric dataflow.googleapis.com/job/user_counter. If you rely
on the custom metrics, you can delete old / unused metric descriptors. See
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.list
and
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.delete
Mar 17, 2023 10:58:56 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:58:54.594Z: Autoscaling: Raised the number of workers
to 5 based on the rate of progress in the currently running stage(s).
Mar 17, 2023 10:59:30 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:29.441Z: Workers have started successfully.
Mar 17, 2023 10:59:52 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:51.794Z: All workers have finished the startup
processes and began to receive work requests.
Mar 17, 2023 10:59:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:55.738Z: Finished operation BeamIOSourceRel_99/Read
Input BQ Rows/TriggerIdCreation/Read(CreateSource)+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/WithKeys/AddKeys/Map+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Partial+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Reify+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Write
Mar 17, 2023 10:59:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:55.813Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Close
Mar 17, 2023 10:59:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:55.875Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Close
Mar 17, 2023 10:59:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:55.945Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Create
Mar 17, 2023 10:59:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:56.145Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Create
Mar 17, 2023 10:59:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:56.293Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Read+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Write
Mar 17, 2023 11:00:00 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:59.389Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Read+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/Combine.GroupedValues/Extract+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Values/Values/Map+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/ParDo(UseWindowHashAsKeyAndWindowAsSortKey)+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Write
Mar 17, 2023 11:00:00 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:59.458Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Close
Mar 17, 2023 11:00:00 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:59.515Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Close
Mar 17, 2023 11:00:00 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T10:59:59.580Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Read+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/ParDo(IsmRecordForSingularValuePerWindow)
Mar 17, 2023 11:00:06 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:00:05.700Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Read+BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/ParDo(IsmRecordForSingularValuePerWindow)
Mar 17, 2023 11:00:06 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:00:05.826Z: Executing operation BeamIOSourceRel_99/Read
Input BQ Rows/ViewId/Combine.GloballyAsSingletonView/CreateDataflowView
Mar 17, 2023 11:00:06 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:00:05.894Z: Finished operation BeamIOSourceRel_99/Read
Input BQ Rows/ViewId/Combine.GloballyAsSingletonView/CreateDataflowView
Mar 17, 2023 11:01:24 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:01:23.512Z: Finished operation BeamIOSourceRel_99/Read
Input BQ Rows/Read(BigQueryTableSource)+BeamIOSourceRel_99/Read Input BQ
Rows/PassThroughThenCleanup/ParMultiDo(Identity)+BeamIOSourceRel_99/ParDo(RowMonitor)+BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/View.AsIterable/ParDo(ToIsmRecordForGlobalWindow)+BeamCalcRel_189/ParMultiDo(Calc)+ParDo(TimeMonitor)
Mar 17, 2023 11:01:24 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:01:23.667Z: Executing operation BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/View.AsIterable/CreateDataflowView
Mar 17, 2023 11:01:24 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:01:23.726Z: Finished operation BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/View.AsIterable/CreateDataflowView
Mar 17, 2023 11:01:24 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:01:23.846Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/Read(CreateSource)+BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup
Mar 17, 2023 11:01:27 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:01:26.592Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/Read(CreateSource)+BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup
Mar 17, 2023 11:01:27 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:01:26.758Z: Cleaning up.
Mar 17, 2023 11:01:27 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:01:26.855Z: Stopping worker pool...
Mar 17, 2023 11:03:37 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:03:37.152Z: Autoscaling: Resized worker pool from 5 to
0.
Mar 17, 2023 11:03:37 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:03:37.229Z: Worker pool stopped.
Mar 17, 2023 11:03:48 AM
org.apache.beam.runners.dataflow.DataflowPipelineJob logTerminalState
INFO: Job 2023-03-17_03_58_00-16403985907829234360 finished with status
DONE.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDefaultMethod STANDARD_OUT
Load test results for test (ID): 5dd80865-4ff7-49fc-9c07-d93fd04eb839 and
timestamp: 2023-03-17T11:03:48.703000000Z:
Metric: Value:
read_time 64.187
fields_read 3.08350476E8
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDefaultMethod STANDARD_ERROR
Mar 17, 2023 11:03:48 AM
org.apache.beam.sdk.testutils.publishing.InfluxDBPublisher publishWithCheck
WARNING: Missing setting InfluxDB database. Metrics won't be published.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_ERROR
Mar 17, 2023 11:03:48 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery method is set to: DIRECT_READ
Mar 17, 2023 11:03:48 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery writeDisposition is set to: WRITE_EMPTY
Mar 17, 2023 11:03:48 AM
org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `HACKER_NEWS`.`by` AS `author`, `HACKER_NEWS`.`type`,
`HACKER_NEWS`.`title`, `HACKER_NEWS`.`score`
FROM `beam`.`HACKER_NEWS` AS `HACKER_NEWS`
WHERE (`HACKER_NEWS`.`type` = 'story' OR `HACKER_NEWS`.`type` = 'job') AND
`HACKER_NEWS`.`score` > 2
Mar 17, 2023 11:03:48 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery method is set to: DIRECT_READ
Mar 17, 2023 11:03:48 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery writeDisposition is set to: WRITE_EMPTY
Mar 17, 2023 11:03:48 AM
org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(author=[$4], type=[$8], title=[$0], score=[$5])
LogicalFilter(condition=[AND(OR(=($8, 'story'), =($8, 'job')), >($5, 2))])
BeamIOSourceRel(table=[[beam, HACKER_NEWS]])
Mar 17, 2023 11:03:49 AM
org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamPushDownIOSourceRel(table=[[beam, HACKER_NEWS]], usedFields=[[by, type,
title, score]], BigQueryFilter=[[supported{OR(=($8, 'story'), =($8,
'job'))>($5, 2)}, unsupported{}]])
Mar 17, 2023 11:03:49 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable
buildIOReader
INFO: Pushing down the following filter: (type = 'story' OR type = 'job')
AND score > 2
Mar 17, 2023 11:03:49 AM org.apache.beam.runners.dataflow.DataflowRunner
validateSdkContainerImageOptions
WARNING: Prefer --sdkContainerImage over deprecated legacy option
--workerHarnessContainerImage.
Mar 17, 2023 11:03:49 AM
org.apache.beam.runners.dataflow.options.DataflowPipelineOptions$StagingLocationFactory
create
INFO: No stagingLocation provided, falling back to gcpTempLocation
Mar 17, 2023 11:03:49 AM org.apache.beam.runners.dataflow.DataflowRunner
fromOptions
INFO: PipelineOptions.filesToStage was not specified. Defaulting to files
from the classpath: will stage 398 files. Enable logging at DEBUG level to see
which files will be staged.
Mar 17, 2023 11:03:50 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Executing pipeline on the Dataflow Service, which will have billing
implications related to Google Compute Engine usage and other Google Cloud
Services.
Mar 17, 2023 11:03:53 AM org.apache.beam.runners.dataflow.util.PackageUtil
stageClasspathElements
INFO: Uploading 399 files from PipelineOptions.filesToStage to staging
location to prepare for execution.
Mar 17, 2023 11:03:53 AM
org.apache.beam.runners.dataflow.util.PackageUtil$PackageAttributes
forFileToStage
INFO: Staging custom dataflow-worker.jar as
beam-runners-google-cloud-dataflow-java-legacy-worker-2.47.0-SNAPSHOT-AuKxsiP6o1sW8t3Mh5QcpnYnsgflhFB_snV_xH2YcXo.jar
Mar 17, 2023 11:03:53 AM org.apache.beam.runners.dataflow.util.PackageUtil
stageClasspathElements
INFO: Staging files complete: 399 files cached, 0 files newly uploaded in 0
seconds
Mar 17, 2023 11:03:53 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Staging portable pipeline proto to
gs://temp-storage-for-perf-tests/loadtests/staging/
Mar 17, 2023 11:03:53 AM org.apache.beam.runners.dataflow.util.PackageUtil
tryStagePackage
INFO: Uploading <155776 bytes, hash
cf240f0aa3ab7b67016970b3846ae5282a50c95c256668ff65fcad6006b00078> to
gs://temp-storage-for-perf-tests/loadtests/staging/pipeline-zyQPCqOre2cBaXCzhGrlKCpQyVwlZmj_ZfytYAawAHg.pb
Mar 17, 2023 11:03:56 AM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding BeamPushDownIOSourceRel_251/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource) as step s1
Mar 17, 2023 11:03:56 AM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding BeamPushDownIOSourceRel_251/ParDo(RowMonitor) as step s2
Mar 17, 2023 11:03:56 AM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding ParDo(TimeMonitor) as step s3
Mar 17, 2023 11:03:56 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Dataflow SDK version: 2.47.0-SNAPSHOT
Mar 17, 2023 11:03:57 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: To access the Dataflow monitoring console, please navigate to
https://console.cloud.google.com/dataflow/jobs/us-central1/2023-03-17_04_03_56-11648713193037763101?project=apache-beam-testing
Mar 17, 2023 11:03:57 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Submitted job: 2023-03-17_04_03_56-11648713193037763101
Mar 17, 2023 11:03:57 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: To cancel the job using the 'gcloud' tool, run:
> gcloud dataflow jobs --project=apache-beam-testing cancel
--region=us-central1 2023-03-17_04_03_56-11648713193037763101
Mar 17, 2023 11:04:01 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
WARNING: 2023-03-17T11:03:58.910Z: The requested max number of workers (5)
is ignored as autoscaling is explicitly disabled (autoscalingAlgorithm=NONE).
Mar 17, 2023 11:04:01 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
WARNING: 2023-03-17T11:04:00.412Z: The workflow name is not a valid Cloud
Label. Labels applied to Cloud resources (such as GCE Instances) for monitoring
will be labeled with this modified job name:
bigqueryiopushdownit0readusingdirectreadmethodpushdown-jen-xfpp. For the best
monitoring experience, please name your job with a valid Cloud Label. For
details, see:
https://cloud.google.com/compute/docs/labeling-resources#restrictions
Mar 17, 2023 11:04:10 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:10.751Z: Worker configuration: e2-standard-2 in
us-central1-b.
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:11.643Z: Expanding CoGroupByKey operations into
optimizable parts.
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:11.682Z: Expanding GroupByKey operations into
optimizable parts.
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:11.715Z: Lifting ValueCombiningMappingFns into
MergeBucketsMappingFns
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:11.769Z: Fusing adjacent ParDo, Read, Write, and
Flatten operations
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:11.800Z: Fusing consumer
BeamPushDownIOSourceRel_251/ParDo(RowMonitor) into
BeamPushDownIOSourceRel_251/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:11.822Z: Fusing consumer ParDo(TimeMonitor) into
BeamPushDownIOSourceRel_251/ParDo(RowMonitor)
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:12.159Z: Executing operation
BeamPushDownIOSourceRel_251/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)+BeamPushDownIOSourceRel_251/ParDo(RowMonitor)+ParDo(TimeMonitor)
Mar 17, 2023 11:04:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:12.223Z: Starting 5 workers in us-central1-b...
Mar 17, 2023 11:04:26 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:23.803Z: Your project already contains 100
Dataflow-created metric descriptors, so new user metrics of the form
custom.googleapis.com/* will not be created. However, all user metrics are also
available in the metric dataflow.googleapis.com/job/user_counter. If you rely
on the custom metrics, you can delete old / unused metric descriptors. See
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.list
and
https://developers.google.com/apis-explorer/#p/monitoring/v3/monitoring.projects.metricDescriptors.delete
Mar 17, 2023 11:04:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:04:51.046Z: Autoscaling: Raised the number of workers
to 5 based on the rate of progress in the currently running stage(s).
Mar 17, 2023 11:05:24 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:05:22.502Z: Workers have started successfully.
Mar 17, 2023 11:05:42 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:05:40.945Z: All workers have finished the startup
processes and began to receive work requests.
Mar 17, 2023 11:06:03 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:06:01.582Z: Finished operation
BeamPushDownIOSourceRel_251/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)+BeamPushDownIOSourceRel_251/ParDo(RowMonitor)+ParDo(TimeMonitor)
Mar 17, 2023 11:06:03 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:06:01.738Z: Cleaning up.
Mar 17, 2023 11:06:03 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:06:01.819Z: Stopping worker pool...
Mar 17, 2023 11:08:12 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:08:11.562Z: Autoscaling: Resized worker pool from 5 to
0.
Mar 17, 2023 11:08:12 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-03-17T11:08:11.602Z: Worker pool stopped.
Mar 17, 2023 11:08:18 AM
org.apache.beam.runners.dataflow.DataflowPipelineJob logTerminalState
INFO: Job 2023-03-17_04_03_56-11648713193037763101 finished with status
DONE.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_OUT
Load test results for test (ID): 9ee434f3-99f4-4b11-ae68-5db2773c5f03 and
timestamp: 2023-03-17T11:08:18.898000000Z:
Metric: Value:
fields_read 4375276.0
read_time 14.019
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_ERROR
Mar 17, 2023 11:08:18 AM
org.apache.beam.sdk.testutils.publishing.InfluxDBPublisher publishWithCheck
WARNING: Missing setting InfluxDB database. Metrics won't be published.
Gradle Test Executor 2 finished executing tests.
> Task :sdks:java:extensions:sql:perf-tests:integrationTest FAILED
3 tests completed, 1 failed
Finished generating test XML results (0.03 secs) into:
<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/ws/src/sdks/java/extensions/sql/perf-tests/build/test-results/integrationTest>
Generating HTML test report...
Finished generating test html results (0.038 secs) into:
<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/ws/src/sdks/java/extensions/sql/perf-tests/build/reports/tests/integrationTest>
:sdks:java:extensions:sql:perf-tests:integrationTest (Thread[Execution worker
Thread 2,5,main]) completed. Took 1 hrs 37 mins 0.92 secs.
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task
':sdks:java:extensions:sql:perf-tests:integrationTest'.
> There were failing tests. See the report at:
> file://<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/ws/src/sdks/java/extensions/sql/perf-tests/build/reports/tests/integrationTest/index.html>
* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --debug option to get more log output.
* Get more help at https://help.gradle.org
Deprecated Gradle features were used in this build, making it incompatible with
Gradle 8.0.
You can use '--warning-mode all' to show the individual deprecation warnings
and determine if they come from your own scripts or plugins.
See
https://docs.gradle.org/7.5.1/userguide/command_line_interface.html#sec:command_line_warnings
BUILD FAILED in 1h 37m 54s
178 actionable tasks: 112 executed, 64 from cache, 2 up-to-date
Publishing build scan...
https://gradle.com/s/eepahctff36fk
Stopped 1 worker daemon(s).
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
