See
<https://ci-beam.apache.org/job/beam_PerformanceTests_SQLBigQueryIO_Batch_Java/447/display/redirect>
Changes:
------------------------------------------
[...truncated 818.93 KB...]
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.444Z: 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
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.466Z: 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
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.484Z: 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
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.504Z: 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
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.522Z: 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
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.541Z: 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)
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.561Z: 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
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.581Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/Create(CleanupOperation)/MapElements/Map
into BeamIOSourceRel_99/Read Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/Impulse
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.601Z: Fusing consumer BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup into BeamIOSourceRel_99/Read Input
BQ Rows/PassThroughThenCleanup/Create(CleanupOperation)/MapElements/Map
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.861Z: 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)
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.884Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Create
Aug 15, 2023 10:35:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:12.917Z: Starting 5 workers in us-central1-a...
Aug 15, 2023 10:35:23 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:22.257Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Create
Aug 15, 2023 10:35:23 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:22.363Z: Executing operation BeamIOSourceRel_99/Read
Input BQ Rows/TriggerIdCreation/Impulse+BeamIOSourceRel_99/Read Input BQ
Rows/TriggerIdCreation/MapElements/Map+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
Aug 15, 2023 10:35:23 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:35:22.911Z: 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
Aug 15, 2023 10:36:03 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:02.271Z: Autoscaling: Raised the number of workers
to 2 based on the rate of progress in the currently running stage(s).
Aug 15, 2023 10:36:03 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:02.292Z: Autoscaling: Resized worker pool to 2,
though goal was 5. This could be a quota issue.
Aug 15, 2023 10:36:13 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:12.069Z: Autoscaling: Raised the number of workers
to 5 based on the rate of progress in the currently running stage(s).
Aug 15, 2023 10:36:36 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:36.174Z: Workers have started successfully.
Aug 15, 2023 10:36:55 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:54.189Z: All workers have finished the startup
processes and began to receive work requests.
Aug 15, 2023 10:36:57 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:56.447Z: Finished operation BeamIOSourceRel_99/Read
Input BQ Rows/TriggerIdCreation/Impulse+BeamIOSourceRel_99/Read Input BQ
Rows/TriggerIdCreation/MapElements/Map+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
Aug 15, 2023 10:36:57 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:56.509Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Close
Aug 15, 2023 10:36:57 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:57.620Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/Combine.globally(Singleton)/Combine.perKey(Singleton)/GroupByKey/Close
Aug 15, 2023 10:37:00 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:57.680Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Create
Aug 15, 2023 10:37:00 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:57.821Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Create
Aug 15, 2023 10:37:00 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:36:57.933Z: 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
Aug 15, 2023 10:37:02 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:02.604Z: 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
Aug 15, 2023 10:37:02 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:02.697Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Close
Aug 15, 2023 10:37:02 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:02.837Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/ViewId/Combine.GloballyAsSingletonView/BatchViewOverrides.GroupByWindowHashAsKeyAndWindowAsSortKey/BatchViewOverrides.GroupByKeyAndSortValuesOnly/Close
Aug 15, 2023 10:37:02 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:02.897Z: 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)
Aug 15, 2023 10:37:07 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:07.026Z: 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)
Aug 15, 2023 10:37:07 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:07.129Z: Executing operation BeamIOSourceRel_99/Read
Input BQ Rows/ViewId/Combine.GloballyAsSingletonView/CreateDataflowView
Aug 15, 2023 10:37:07 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:07.178Z: Finished operation BeamIOSourceRel_99/Read
Input BQ Rows/ViewId/Combine.GloballyAsSingletonView/CreateDataflowView
Aug 15, 2023 10:37:55 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:53.175Z: 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)
Aug 15, 2023 10:37:55 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:53.274Z: Executing operation BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/View.AsIterable/CreateDataflowView
Aug 15, 2023 10:37:55 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:53.324Z: Finished operation BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/View.AsIterable/CreateDataflowView
Aug 15, 2023 10:37:55 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:53.428Z: Executing operation BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/Impulse+BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/MapElements/Map+BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup
Aug 15, 2023 10:37:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:56.025Z: Finished operation BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/Impulse+BeamIOSourceRel_99/Read
Input BQ
Rows/PassThroughThenCleanup/Create(CleanupOperation)/MapElements/Map+BeamIOSourceRel_99/Read
Input BQ Rows/PassThroughThenCleanup/Cleanup
Aug 15, 2023 10:37:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:56.185Z: Cleaning up.
Aug 15, 2023 10:37:58 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:37:56.344Z: Stopping worker pool...
Aug 15, 2023 10:40:19 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:19.332Z: Autoscaling: Resized worker pool from 5 to
0.
Aug 15, 2023 10:40:19 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:19.416Z: Worker pool stopped.
Aug 15, 2023 10:40:24 AM
org.apache.beam.runners.dataflow.DataflowPipelineJob logTerminalState
INFO: Job 2023-08-15_03_34_54-7887640841171873351 finished with status DONE.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDefaultMethod STANDARD_OUT
Load test results for test (ID): 37d2b9b4-54dc-4f84-8768-212daed5d609 and
timestamp: 2023-08-15T10:40:24.957000000Z:
Metric: Value:
read_time 37.45
fields_read 3.08350476E8
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDefaultMethod STANDARD_ERROR
Aug 15, 2023 10:40:25 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
Aug 15, 2023 10:40:25 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery method is set to: DIRECT_READ
Aug 15, 2023 10:40:25 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery writeDisposition is set to: WRITE_EMPTY
Aug 15, 2023 10:40:25 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
Aug 15, 2023 10:40:25 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery method is set to: DIRECT_READ
Aug 15, 2023 10:40:25 AM
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryTable <init>
INFO: BigQuery writeDisposition is set to: WRITE_EMPTY
Aug 15, 2023 10:40:25 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]])
Aug 15, 2023 10:40:25 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{}]])
Aug 15, 2023 10:40:25 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
Aug 15, 2023 10:40:25 AM org.apache.beam.runners.dataflow.DataflowRunner
validateSdkContainerImageOptions
WARNING: Prefer --sdkContainerImage over deprecated legacy option
--workerHarnessContainerImage.
Aug 15, 2023 10:40:25 AM
org.apache.beam.runners.dataflow.options.DataflowPipelineOptions$StagingLocationFactory
create
INFO: No stagingLocation provided, falling back to gcpTempLocation
Aug 15, 2023 10:40:26 AM org.apache.beam.runners.dataflow.DataflowRunner
fromOptions
INFO: PipelineOptions.filesToStage was not specified. Defaulting to files
from the classpath: will stage 404 files. Enable logging at DEBUG level to see
which files will be staged.
Aug 15, 2023 10:40:26 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.
Aug 15, 2023 10:40:30 AM org.apache.beam.runners.dataflow.util.PackageUtil
stageClasspathElements
INFO: Uploading 405 files from PipelineOptions.filesToStage to staging
location to prepare for execution.
Aug 15, 2023 10:40:30 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.51.0-SNAPSHOT-43WEeREc8LwznId0kaPHopgW8Cxs_AxHzZk7LN2NyQw.jar
Aug 15, 2023 10:40:30 AM org.apache.beam.runners.dataflow.util.PackageUtil
stageClasspathElements
INFO: Staging files complete: 405 files cached, 0 files newly uploaded in 0
seconds
Aug 15, 2023 10:40:30 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Staging portable pipeline proto to
gs://temp-storage-for-perf-tests/loadtests/staging/
Aug 15, 2023 10:40:30 AM org.apache.beam.runners.dataflow.util.PackageUtil
tryStagePackage
INFO: Uploading <157960 bytes, hash
1a3bb25171b151b539dfbe89f2d5b2e0276668935a0d65f978414c62f3b533a9> to
gs://temp-storage-for-perf-tests/loadtests/staging/pipeline-GjuyUXGxUbU5376J8tWy4CdmaJNaDWX5eEFMYvO1M6k.pb
Aug 15, 2023 10:40:34 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
Aug 15, 2023 10:40:34 AM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding BeamPushDownIOSourceRel_251/ParDo(RowMonitor) as step s2
Aug 15, 2023 10:40:34 AM
org.apache.beam.runners.dataflow.DataflowPipelineTranslator$Translator addStep
INFO: Adding ParDo(TimeMonitor) as step s3
Aug 15, 2023 10:40:34 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Dataflow SDK version: 2.51.0-SNAPSHOT
Aug 15, 2023 10:40:36 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-08-15_03_40_34-16294677092881158839?project=apache-beam-testing
Aug 15, 2023 10:40:36 AM org.apache.beam.runners.dataflow.DataflowRunner run
INFO: Submitted job: 2023-08-15_03_40_34-16294677092881158839
Aug 15, 2023 10:40:36 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-08-15_03_40_34-16294677092881158839
Aug 15, 2023 10:40:37 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
WARNING: 2023-08-15T10:40:37.234Z: The requested max number of workers (5)
is ignored as autoscaling is explicitly disabled (autoscalingAlgorithm=NONE).
Aug 15, 2023 10:40:40 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
WARNING: 2023-08-15T10:40:38.303Z: 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-p402. 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
Aug 15, 2023 10:40:50 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:49.895Z: Worker configuration: e2-standard-2 in
us-central1-b.
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.027Z: Expanding CoGroupByKey operations into
optimizable parts.
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.069Z: Expanding GroupByKey operations into
optimizable parts.
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.088Z: Lifting ValueCombiningMappingFns into
MergeBucketsMappingFns
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.142Z: Fusing adjacent ParDo, Read, Write, and
Flatten operations
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.163Z: Fusing consumer
BeamPushDownIOSourceRel_251/ParDo(RowMonitor) into
BeamPushDownIOSourceRel_251/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.186Z: Fusing consumer ParDo(TimeMonitor) into
BeamPushDownIOSourceRel_251/ParDo(RowMonitor)
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.484Z: Executing operation
BeamPushDownIOSourceRel_251/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)+BeamPushDownIOSourceRel_251/ParDo(RowMonitor)+ParDo(TimeMonitor)
Aug 15, 2023 10:40:51 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:40:51.553Z: Starting 5 workers in us-central1-b...
Aug 15, 2023 10:41:14 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:41:12.788Z: 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
Aug 15, 2023 10:41:39 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:41:37.459Z: Autoscaling: Raised the number of workers
to 1 based on the rate of progress in the currently running stage(s).
Aug 15, 2023 10:41:39 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:41:37.481Z: Autoscaling: Resized worker pool to 1,
though goal was 5. This could be a quota issue.
Aug 15, 2023 10:41:47 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:41:47.300Z: Autoscaling: Raised the number of workers
to 5 based on the rate of progress in the currently running stage(s).
Aug 15, 2023 10:42:14 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:42:13.933Z: Workers have started successfully.
Aug 15, 2023 10:42:32 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:42:32.110Z: All workers have finished the startup
processes and began to receive work requests.
Aug 15, 2023 10:42:46 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:42:45.385Z: Finished operation
BeamPushDownIOSourceRel_251/Read Input BQ Rows with
push-down/Read(BigQueryStorageTableSource)+BeamPushDownIOSourceRel_251/ParDo(RowMonitor)+ParDo(TimeMonitor)
Aug 15, 2023 10:42:46 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:42:45.550Z: Cleaning up.
Aug 15, 2023 10:42:46 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:42:45.635Z: Stopping worker pool...
Aug 15, 2023 10:45:18 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:45:17.498Z: Autoscaling: Resized worker pool from 5 to
0.
Aug 15, 2023 10:45:18 AM
org.apache.beam.runners.dataflow.util.MonitoringUtil$LoggingHandler process
INFO: 2023-08-15T10:45:17.579Z: Worker pool stopped.
Aug 15, 2023 10:45:24 AM
org.apache.beam.runners.dataflow.DataflowPipelineJob logTerminalState
INFO: Job 2023-08-15_03_40_34-16294677092881158839 finished with status
DONE.
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_OUT
Load test results for test (ID): acf1681c-e265-448d-893a-af7b144ad85a and
timestamp: 2023-08-15T10:45:24.882000000Z:
Metric: Value:
fields_read 4375276.0
read_time 7.849
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryIOPushDownIT
> readUsingDirectReadMethodPushDown STANDARD_ERROR
Aug 15, 2023 10:45:24 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.046 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.044 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>
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.6.2/userguide/command_line_interface.html#sec:command_line_warnings
BUILD FAILED in 1h 15m
183 actionable tasks: 112 executed, 69 from cache, 2 up-to-date
Publishing build scan...
https://ge.apache.org/s/d4ilv7q73thco
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]
