See
<https://builds.apache.org/job/beam_PostCommit_Java_GradleBuild/1102/display/redirect?page=changes>
Changes:
[daniel.o.programmer] [BEAM-3709] Implementing new combine URNs in python.
[kedin] [SQL] Enable running BeamSqlLine from gradle
[lcwik] [BEAM-4866] Fix missing licenses.
[pablo] Removing scoped metrics container
[pablo] Remove old style metrics context management
[garrettjonesgoogle] Bumping versions that were missed in #5988
[lcwik] [BEAM-4176] Initial implementation for running portable runner tests
[pablo] Fix Java Nightly Snapshot Failures
------------------------------------------
[...truncated 12.34 MB...]
Jul 26, 2018 12:10:43 AM org.apache.beam.sdk.io.gcp.bigquery.BatchLoads$4
getTempFilePrefix
INFO: Writing BigQuery temporary files to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2/
before loading them.
Jul 26, 2018 12:10:43 AM org.apache.beam.sdk.io.gcp.bigquery.TableRowWriter
<init>
INFO: Opening TableRowWriter to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2/eddb4a55-bf2e-45f6-857d-f6f35b12a842.
Jul 26, 2018 12:10:43 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Loading 1 files into {datasetId=integ_test,
projectId=apache-beam-testing,
tableId=BigQueryReadWriteIT_testSQLTypes_2018_07_26_00_10_38_290_7331836372753424765}
using job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0,
location=US, projectId=apache-beam-testing}, attempt 0
org.apache.beam.sdk.extensions.sql.PubsubToBigqueryIT > testSimpleInsert
STANDARD_ERROR
Jul 26, 2018 12:10:44 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubToBigqueryIT-testSimpleInsert-2018-07-26-00-10-38-841-events-895187437625804595_beam_-2462694031356663951
to topic
projects/apache-beam-testing/topics/integ-test-PubsubToBigqueryIT-testSimpleInsert-2018-07-26-00-10-38-841-events-895187437625804595.
Note this subscription WILL NOT be deleted when the pipeline terminates
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testSQLTypes STANDARD_ERROR
Jul 26, 2018 12:10:44 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0
Jul 26, 2018 12:10:44 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0,
location=US, projectId=apache-beam-testing} started
Jul 26, 2018 12:10:44 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0
Jul 26, 2018 12:10:45 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0,
location=US, projectId=apache-beam-testing} completed in state DONE
Jul 26, 2018 12:10:45 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins072600104229ade608_73a584f9275d4859ad6806a95b4b2de2_f0dfc4a06d17a7a0e4f125e401a1f502_00001_00000-0,
location=US, projectId=apache-beam-testing} succeeded. Statistics:
{"creationTime":"1532563843896","endTime":"1532563845062","load":{"badRecords":"0","inputFileBytes":"243","inputFiles":"1","outputBytes":"82","outputRows":"1"},"startTime":"1532563844243"}
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testSQLRead STANDARD_ERROR
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$DatasetServiceImpl
createTable
INFO: Trying to create BigQuery table:
apache-beam-testing:integ_test.BigQueryReadWriteIT_testSQLRead_2018_07_26_00_10_46_114_1917335022943530465
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$DatasetServiceImpl
createTable
INFO: Trying to create BigQuery table:
apache-beam-testing:integ_test.BigQueryReadWriteIT_testSQLRead_2018_07_26_00_10_46_281_7937371439236118950
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
INSERT INTO `beam`.`TEST`
VALUES ROW(9223372036854775807, 127, 32767, 2147483647, 1.0, 1.0, TRUE,
TIMESTAMP '2018-05-28 20:17:40.123', 'varchar', 'char', ARRAY['123', '456'])
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
BeamIOSinkRel(table=[[beam, TEST]], operation=[INSERT], flattened=[true])
LogicalProject(c_bigint=[9223372036854775807], c_tinyint=[127],
c_smallint=[32767], c_integer=[2147483647], c_float=[1.0], c_double=[1.0],
c_boolean=[true], c_timestamp=[2018-05-28 20:17:40.123], c_varchar=['varchar'],
c_char=['char'], c_arr=[ARRAY('123', '456')])
LogicalValues(tuples=[[{ 0 }]])
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamIOSinkRel(table=[[beam, TEST]], operation=[INSERT], flattened=[true])
BeamCalcRel(expr#0=[{inputs}], expr#1=[9223372036854775807],
expr#2=[127], expr#3=[32767], expr#4=[2147483647], expr#5=[1.0], expr#6=[true],
expr#7=[2018-05-28 20:17:40.123], expr#8=['varchar'], expr#9=['char'],
expr#10=['123'], expr#11=['456'], expr#12=[ARRAY($t10, $t11)], c_bigint=[$t1],
c_tinyint=[$t2], c_smallint=[$t3], c_integer=[$t4], c_float=[$t5],
c_double=[$t5], c_boolean=[$t6], c_timestamp=[$t7], c_varchar=[$t8],
c_char=[$t9], c_arr=[$t12])
BeamValuesRel(tuples=[[{ 0 }]])
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
INSERT INTO `beam`.`TEST`
VALUES ROW(9223372036854775807, 127, 32767, 2147483647, 1.0, 1.0, TRUE,
TIMESTAMP '2018-05-28 20:17:40.123', 'varchar', 'char', ARRAY['123', '456'])
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
BeamIOSinkRel(table=[[beam, TEST]], operation=[INSERT], flattened=[true])
LogicalProject(c_bigint=[9223372036854775807], c_tinyint=[127],
c_smallint=[32767], c_integer=[2147483647], c_float=[1.0], c_double=[1.0],
c_boolean=[true], c_timestamp=[2018-05-28 20:17:40.123], c_varchar=['varchar'],
c_char=['char'], c_arr=[ARRAY('123', '456')])
LogicalValues(tuples=[[{ 0 }]])
Jul 26, 2018 12:10:46 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamIOSinkRel(table=[[beam, TEST]], operation=[INSERT], flattened=[true])
BeamCalcRel(expr#0=[{inputs}], expr#1=[9223372036854775807],
expr#2=[127], expr#3=[32767], expr#4=[2147483647], expr#5=[1.0], expr#6=[true],
expr#7=[2018-05-28 20:17:40.123], expr#8=['varchar'], expr#9=['char'],
expr#10=['123'], expr#11=['456'], expr#12=[ARRAY($t10, $t11)], c_bigint=[$t1],
c_tinyint=[$t2], c_smallint=[$t3], c_integer=[$t4], c_float=[$t5],
c_double=[$t5], c_boolean=[$t6], c_timestamp=[$t7], c_varchar=[$t8],
c_char=[$t9], c_arr=[$t12])
BeamValuesRel(tuples=[[{ 0 }]])
Jul 26, 2018 12:10:46 AM org.apache.beam.sdk.io.gcp.bigquery.BatchLoads$4
getTempFilePrefix
INFO: Writing BigQuery temporary files to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2/
before loading them.
Jul 26, 2018 12:10:46 AM org.apache.beam.sdk.io.gcp.bigquery.TableRowWriter
<init>
INFO: Opening TableRowWriter to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2/e9e3e142-f56a-429d-9eb8-70cf493bf266.
Jul 26, 2018 12:10:47 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Loading 1 files into {datasetId=integ_test,
projectId=apache-beam-testing,
tableId=BigQueryReadWriteIT_testSQLRead_2018_07_26_00_10_46_114_1917335022943530465}
using job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0,
location=US, projectId=apache-beam-testing}, attempt 0
Jul 26, 2018 12:10:47 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0
Jul 26, 2018 12:10:47 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0,
location=US, projectId=apache-beam-testing} started
Jul 26, 2018 12:10:48 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0
Jul 26, 2018 12:10:48 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0
org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT >
testSelectsPayloadContent STANDARD_ERROR
Jul 26, 2018 12:10:49 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testSelectsPayloadContent-2018-07-26-00-10-39-979-events--5162718087988606512_beam_-2550660355891607217
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testSelectsPayloadContent-2018-07-26-00-10-39-979-events--5162718087988606512.
Note this subscription WILL NOT be deleted when the pipeline terminates
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testSQLRead STANDARD_ERROR
Jul 26, 2018 12:10:49 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0,
location=US, projectId=apache-beam-testing} completed in state DONE
Jul 26, 2018 12:10:49 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins07260010465529f680_ae6c1fd9aeef47f4b820bd6bca0304f2_e67b1b6f33dba5694fbce312e8ae9046_00001_00000-0,
location=US, projectId=apache-beam-testing} succeeded. Statistics:
{"creationTime":"1532563847681","endTime":"1532563848781","load":{"badRecords":"0","inputFileBytes":"243","inputFiles":"1","outputBytes":"82","outputRows":"1"},"startTime":"1532563847942"}
Jul 26, 2018 12:10:50 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `TEST`.`c_bigint`, `TEST`.`c_tinyint`, `TEST`.`c_smallint`,
`TEST`.`c_integer`, `TEST`.`c_float`, `TEST`.`c_double`, `TEST`.`c_boolean`,
`TEST`.`c_timestamp`, `TEST`.`c_varchar`, `TEST`.`c_char`, `TEST`.`c_arr`
FROM `beam`.`TEST` AS `TEST`
Jul 26, 2018 12:10:50 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c_bigint=[$0], c_tinyint=[$1], c_smallint=[$2],
c_integer=[$3], c_float=[$4], c_double=[$5], c_boolean=[$6], c_timestamp=[$7],
c_varchar=[$8], c_char=[$9], c_arr=[$10])
BeamIOSourceRel(table=[[beam, TEST]])
Jul 26, 2018 12:10:50 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..10=[{inputs}], proj#0..10=[{exprs}])
BeamIOSourceRel(table=[[beam, TEST]])
Jul 26, 2018 12:10:50 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase executeExtract
INFO: Starting BigQuery extract job:
beam_job_7c5514046e914418b6baf38698a629ef_bigqueryreadwriteit0testsqlreadjenkins0726001050f1d8281f-extract
Jul 26, 2018 12:10:51 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_job_7c5514046e914418b6baf38698a629ef_bigqueryreadwriteit0testsqlreadjenkins0726001050f1d8281f-extract,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_job_7c5514046e914418b6baf38698a629ef_bigqueryreadwriteit0testsqlreadjenkins0726001050f1d8281f-extract
Jul 26, 2018 12:10:51 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_job_7c5514046e914418b6baf38698a629ef_bigqueryreadwriteit0testsqlreadjenkins0726001050f1d8281f-extract,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_job_7c5514046e914418b6baf38698a629ef_bigqueryreadwriteit0testsqlreadjenkins0726001050f1d8281f-extract
Jul 26, 2018 12:10:52 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_job_7c5514046e914418b6baf38698a629ef_bigqueryreadwriteit0testsqlreadjenkins0726001050f1d8281f-extract,
location=US, projectId=apache-beam-testing} completed in state DONE
Jul 26, 2018 12:10:52 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase executeExtract
INFO: BigQuery extract job completed:
beam_job_7c5514046e914418b6baf38698a629ef_bigqueryreadwriteit0testsqlreadjenkins0726001050f1d8281f-extract
Jul 26, 2018 12:10:52 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase split
INFO: Extract job produced 1 files
Jul 26, 2018 12:10:52 AM org.apache.beam.sdk.io.FileBasedSource createReader
INFO: Matched 1 files for pattern
gs://temp-storage-for-end-to-end-tests/BigQueryExtractTemp/7c5514046e914418b6baf38698a629ef/000000000000.avro
Jul 26, 2018 12:10:52 AM org.apache.beam.sdk.io.FileBasedSource
getEstimatedSizeBytes
INFO: Filepattern
gs://temp-storage-for-end-to-end-tests/BigQueryExtractTemp/7c5514046e914418b6baf38698a629ef/000000000000.avro
matched 1 files with total size 738
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testInsertSelect STANDARD_ERROR
Jul 26, 2018 12:10:53 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$DatasetServiceImpl
createTable
INFO: Trying to create BigQuery table:
apache-beam-testing:integ_test.BigQueryReadWriteIT_testInsertSelect_2018_07_26_00_10_53_480_7194864902538965097
Jul 26, 2018 12:10:53 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$DatasetServiceImpl
createTable
INFO: Trying to create BigQuery table:
apache-beam-testing:integ_test.BigQueryReadWriteIT_testInsertSelect_2018_07_26_00_10_53_670_3752531385123650647
Jul 26, 2018 12:10:53 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
INSERT INTO `beam`.`ORDERS_BQ`
(SELECT `ORDERS_IN_MEMORY`.`id` AS `id`, `ORDERS_IN_MEMORY`.`name` AS
`name`, `ORDERS_IN_MEMORY`.`arr` AS `arr`
FROM `beam`.`ORDERS_IN_MEMORY` AS `ORDERS_IN_MEMORY`)
Jul 26, 2018 12:10:53 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
BeamIOSinkRel(table=[[beam, ORDERS_BQ]], operation=[INSERT],
flattened=[true])
LogicalProject(id=[$0], name=[$1], arr=[$2])
BeamIOSourceRel(table=[[beam, ORDERS_IN_MEMORY]])
Jul 26, 2018 12:10:53 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamIOSinkRel(table=[[beam, ORDERS_BQ]], operation=[INSERT],
flattened=[true])
BeamCalcRel(expr#0..2=[{inputs}], proj#0..2=[{exprs}])
BeamIOSourceRel(table=[[beam, ORDERS_IN_MEMORY]])
Jul 26, 2018 12:10:54 AM org.apache.beam.sdk.io.gcp.bigquery.BatchLoads$4
getTempFilePrefix
INFO: Writing BigQuery temporary files to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c/
before loading them.
Jul 26, 2018 12:10:54 AM org.apache.beam.sdk.io.gcp.bigquery.TableRowWriter
<init>
INFO: Opening TableRowWriter to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c/93264b3e-ac4c-49c5-8601-97ff52a4c8ab.
Jul 26, 2018 12:10:54 AM org.apache.beam.sdk.io.gcp.bigquery.TableRowWriter
<init>
INFO: Opening TableRowWriter to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c/6731784e-e04d-4ad7-a135-5c00c1cbd458.
Jul 26, 2018 12:10:54 AM org.apache.beam.sdk.io.gcp.bigquery.TableRowWriter
<init>
INFO: Opening TableRowWriter to
gs://temp-storage-for-end-to-end-tests/BigQueryWriteTemp/beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c/63f4b5f5-d81b-4b1d-9e11-cba649075de2.
Jul 26, 2018 12:10:54 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Loading 3 files into {datasetId=integ_test,
projectId=apache-beam-testing,
tableId=BigQueryReadWriteIT_testInsertSelect_2018_07_26_00_10_53_670_3752531385123650647}
using job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0,
location=US, projectId=apache-beam-testing}, attempt 0
Jul 26, 2018 12:10:55 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0
Jul 26, 2018 12:10:55 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0,
location=US, projectId=apache-beam-testing} started
Jul 26, 2018 12:10:55 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0
Jul 26, 2018 12:10:55 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0
Jul 26, 2018 12:10:57 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0,
location=US, projectId=apache-beam-testing} completed in state DONE
Jul 26, 2018 12:10:57 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0726001054496fb1e4_b504af4fdee44325b3482f25ce5b385c_cb82d8b5aafd68bc1e95bbef6121073b_00001_00000-0,
location=US, projectId=apache-beam-testing} succeeded. Statistics:
{"creationTime":"1532563854771","endTime":"1532563856032","load":{"badRecords":"0","inputFileBytes":"126","inputFiles":"3","outputBytes":"69","outputRows":"3"},"startTime":"1532563855058"}
Gradle Test Executor 121 finished executing tests.
Gradle Test Executor 123 finished executing tests.
> Task :beam-sdks-java-extensions-sql:integrationTest
org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT >
testSelectsPayloadContent STANDARD_ERROR
Jul 26, 2018 12:11:17 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription--3923383742063682850
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT >
testUsesDlq STANDARD_ERROR
Jul 26, 2018 12:11:20 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `message`.`payload`.`id`, `message`.`payload`.`name`
FROM `beam`.`message` AS `message`
Jul 26, 2018 12:11:20 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$3])
LogicalProject(event_timestamp=[$0], attributes=[$1], id=[$2.id],
name=[$2.name])
BeamIOSourceRel(table=[[beam, message]])
Jul 26, 2018 12:11:20 AM
org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[$t2.id], expr#4=[$t2.name],
id=[$t3], name=[$t4])
BeamIOSourceRel(table=[[beam, message]])
Jul 26, 2018 12:11:26 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testUsesDlq-2018-07-26-00-11-20-262-events-7591379636188574256_beam_2994014744234356986
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testUsesDlq-2018-07-26-00-11-20-262-events-7591379636188574256.
Note this subscription WILL NOT be deleted when the pipeline terminates
Jul 26, 2018 12:11:29 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testUsesDlq-2018-07-26-00-11-20-508-events--5180689665717873516_beam_-7660753143878830846
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testUsesDlq-2018-07-26-00-11-20-508-events--5180689665717873516.
Note this subscription WILL NOT be deleted when the pipeline terminates
Jul 26, 2018 12:11:44 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/start-subscription--6761510226531377848
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
Jul 26, 2018 12:12:05 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription-7984567964423849974
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
Jul 26, 2018 12:12:20 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription-7984567964423849974
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
Jul 26, 2018 12:12:36 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription-7984567964423849974
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT >
testSQLLimit STANDARD_ERROR
Jul 26, 2018 12:12:43 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testSQLLimit-2018-07-26-00-12-40-376-events-1106750951017398418_beam_236610356537028087
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testSQLLimit-2018-07-26-00-12-40-376-events-1106750951017398418.
Note this subscription WILL NOT be deleted when the pipeline terminates
Gradle Test Executor 122 finished executing tests.
> Task :beam-sdks-java-extensions-sql:integrationTest
Finished generating test XML results (0.002 secs) into:
<https://builds.apache.org/job/beam_PostCommit_Java_GradleBuild/ws/src/sdks/java/extensions/sql/build/test-results/integrationTest>
Generating HTML test report...
Finished generating test html results (0.004 secs) into:
<https://builds.apache.org/job/beam_PostCommit_Java_GradleBuild/ws/src/sdks/java/extensions/sql/build/reports/tests/integrationTest>
Packing task ':beam-sdks-java-extensions-sql:integrationTest'
:beam-sdks-java-extensions-sql:integrationTest (Thread[Task worker for ':'
Thread 3,5,main]) completed. Took 3 mins 9.164 secs.
:beam-sdks-java-extensions-sql:postCommit (Thread[Task worker for ':' Thread
3,5,main]) started.
> Task :beam-sdks-java-extensions-sql:postCommit
Skipping task ':beam-sdks-java-extensions-sql:postCommit' as it has no actions.
:beam-sdks-java-extensions-sql:postCommit (Thread[Task worker for ':' Thread
3,5,main]) completed. Took 0.0 secs.
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task
':beam-sdks-java-extensions-google-cloud-platform-core:compileTestJava'.
> Compilation failed with exit code 1; see the compiler error output for
> details.
* Try:
Run with --stacktrace option to get the stack trace. Run with --debug option to
get more log output. Run with --scan to get full insights.
* Get more help at https://help.gradle.org
Deprecated Gradle features were used in this build, making it incompatible with
Gradle 5.0.
See
https://docs.gradle.org/4.8/userguide/command_line_interface.html#sec:command_line_warnings
BUILD FAILED in 13m 36s
622 actionable tasks: 621 executed, 1 from cache
Publishing build scan...
https://gradle.com/s/kxsyoewdgfvaq
Stopped 1 worker daemon(s).
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
