See <https://builds.apache.org/job/beam_PostCommit_Java_GradleBuild/1209/display/redirect?page=changes>
Changes: [gene] Adding in additional options for BigQuery.IO insert statements ------------------------------------------ [...truncated 12.66 MB...] org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT > testSQLTypes STANDARD_ERROR Aug 09, 2018 12:07:25 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: BigQuery job {jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins0809000721a458629c_13f0ef26112d46f4b1150672ea6422be_0948efe45d0c1506d14b9866c3554d87_00001_00000-0, location=US, projectId=apache-beam-testing} completed in state DONE Aug 09, 2018 12:07:25 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables load INFO: Load job {jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins0809000721a458629c_13f0ef26112d46f4b1150672ea6422be_0948efe45d0c1506d14b9866c3554d87_00001_00000-0, location=US, projectId=apache-beam-testing} succeeded. Statistics: {"completionRatio":1.0,"creationTime":"1533773242700","endTime":"1533773244324","load":{"badRecords":"0","inputFileBytes":"243","inputFiles":"1","outputBytes":"82","outputRows":"1"},"startTime":"1533773243054"} org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT > testSQLRead STANDARD_ERROR Aug 09, 2018 12:07:26 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_08_09_00_07_26_566_8085044563084490588 Aug 09, 2018 12:07:26 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_08_09_00_07_26_796_3980729694177072601 Aug 09, 2018 12:07:27 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']) Aug 09, 2018 12:07:27 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 }]]) Aug 09, 2018 12:07:27 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 }]]) Aug 09, 2018 12:07:27 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']) Aug 09, 2018 12:07:27 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 }]]) Aug 09, 2018 12:07:27 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 }]]) Aug 09, 2018 12:07:27 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_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6/ before loading them. Aug 09, 2018 12:07:27 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_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6/12a4c21d-f56f-41d1-a079-984b318fbd18. Aug 09, 2018 12:07:28 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_08_09_00_07_26_566_8085044563084490588} using job {jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0, location=US, projectId=apache-beam-testing}, attempt 1 Aug 09, 2018 12:07:29 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob INFO: Started BigQuery job: {jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0, location=US, projectId=apache-beam-testing}. bq show -j --format=prettyjson --project_id=apache-beam-testing beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0 Aug 09, 2018 12:07:29 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables load INFO: Load job {jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0, location=US, projectId=apache-beam-testing} started Aug 09, 2018 12:07:29 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: Still waiting for BigQuery job beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0, currently in status {"state":"RUNNING"} bq show -j --format=prettyjson --project_id=apache-beam-testing beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0 Aug 09, 2018 12:07:30 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: Still waiting for BigQuery job beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0, currently in status {"state":"RUNNING"} bq show -j --format=prettyjson --project_id=apache-beam-testing beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0 Aug 09, 2018 12:07:30 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: BigQuery job {jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0, location=US, projectId=apache-beam-testing} completed in state DONE Aug 09, 2018 12:07:30 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables load INFO: Load job {jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0809000727f8f8ca9e_5ee1ee117c214ce4a76b24f61ae833b6_8b293c4bf6b3619dddc0b7f58828d67c_00001_00000-0, location=US, projectId=apache-beam-testing} succeeded. Statistics: {"creationTime":"1533773248507","endTime":"1533773250033","load":{"badRecords":"0","inputFileBytes":"243","inputFiles":"1","outputBytes":"82","outputRows":"1"},"startTime":"1533773248966"} Aug 09, 2018 12:07:31 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` Aug 09, 2018 12:07:31 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]]) Aug 09, 2018 12:07:31 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]]) Aug 09, 2018 12:07:32 AM org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase executeExtract INFO: Starting BigQuery extract job: beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract Aug 09, 2018 12:07:32 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob INFO: Started BigQuery job: {jobId=beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract, location=US, projectId=apache-beam-testing}. bq show -j --format=prettyjson --project_id=apache-beam-testing beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract Aug 09, 2018 12:07:32 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: Still waiting for BigQuery job beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract, currently in status {"state":"RUNNING"} bq show -j --format=prettyjson --project_id=apache-beam-testing beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract Aug 09, 2018 12:07:33 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: Still waiting for BigQuery job beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract, currently in status {"state":"RUNNING"} bq show -j --format=prettyjson --project_id=apache-beam-testing beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract Aug 09, 2018 12:07:34 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: BigQuery job {jobId=beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract, location=US, projectId=apache-beam-testing} completed in state DONE Aug 09, 2018 12:07:34 AM org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase executeExtract INFO: BigQuery extract job completed: beam_job_221470348bbb4c35a7bd20d51b77f41f_bigqueryreadwriteit0testsqlreadjenkins0809000731fc2266de-extract Aug 09, 2018 12:07:34 AM org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase split INFO: Extract job produced 1 files Aug 09, 2018 12:07:34 AM org.apache.beam.sdk.io.FileBasedSource createReader INFO: Matched 1 files for pattern gs://temp-storage-for-end-to-end-tests/BigQueryExtractTemp/221470348bbb4c35a7bd20d51b77f41f/000000000000.avro Aug 09, 2018 12:07:35 AM org.apache.beam.sdk.io.FileBasedSource getEstimatedSizeBytes INFO: Filepattern gs://temp-storage-for-end-to-end-tests/BigQueryExtractTemp/221470348bbb4c35a7bd20d51b77f41f/000000000000.avro matched 1 files with total size 738 org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT > testInsertSelect STANDARD_ERROR Aug 09, 2018 12:07:35 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_08_09_00_07_35_723_8505347823322362649 Aug 09, 2018 12:07:35 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_08_09_00_07_35_930_1968844309981164285 Aug 09, 2018 12:07:36 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`) Aug 09, 2018 12:07:36 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]]) Aug 09, 2018 12:07:36 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]]) Aug 09, 2018 12:07:36 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_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9/ before loading them. Aug 09, 2018 12:07:36 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_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9/ed2d2556-813f-4ee9-bd74-ec6b8c798d0f. Aug 09, 2018 12:07:36 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_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9/86817cc6-c0fd-4831-8a9d-65533c0af86a. Aug 09, 2018 12:07:36 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_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9/a8451aa5-6675-4549-8f67-a8ff19b102c5. Aug 09, 2018 12:07:37 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_08_09_00_07_35_930_1968844309981164285} using job {jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0, location=US, projectId=apache-beam-testing}, attempt 1 Aug 09, 2018 12:07:37 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob INFO: Started BigQuery job: {jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0, location=US, projectId=apache-beam-testing}. bq show -j --format=prettyjson --project_id=apache-beam-testing beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0 Aug 09, 2018 12:07:37 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables load INFO: Load job {jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0, location=US, projectId=apache-beam-testing} started Aug 09, 2018 12:07:37 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: Still waiting for BigQuery job beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0, currently in status {"state":"RUNNING"} bq show -j --format=prettyjson --project_id=apache-beam-testing beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0 Aug 09, 2018 12:07:39 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: Still waiting for BigQuery job beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0, currently in status {"state":"RUNNING"} bq show -j --format=prettyjson --project_id=apache-beam-testing beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0 Gradle Test Executor 120 finished executing tests. > Task :beam-sdks-java-extensions-sql:integrationTest Aug 09, 2018 12:07:41 AM org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob INFO: BigQuery job {jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0, location=US, projectId=apache-beam-testing} completed in state DONE Aug 09, 2018 12:07:41 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables load INFO: Load job {jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins0809000736c8df43a8_1b6a6b6adc394aba85e7bfdc53d85fb9_ea6944821c0b2fe6a4435181d094e58c_00001_00000-0, location=US, projectId=apache-beam-testing} succeeded. Statistics: {"completionRatio":1.0,"creationTime":"1533773257471","endTime":"1533773259041","load":{"badRecords":"0","inputFileBytes":"126","inputFiles":"3","outputBytes":"69","outputRows":"3"},"startTime":"1533773257853"} Gradle Test Executor 118 finished executing tests. > Task :beam-sdks-java-extensions-sql:integrationTest org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT > testUsesDlq STANDARD_ERROR Aug 09, 2018 12:07:57 AM org.apache.beam.sdk.extensions.sql.impl.BeamQueryPlanner convertToBeamRel INFO: SQL: SELECT `message`.`payload`.`id`, `message`.`payload`.`name` FROM `beam`.`message` AS `message` Aug 09, 2018 12:07:57 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]]) Aug 09, 2018 12:07:57 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]]) Aug 09, 2018 12:08:00 AM org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription WARNING: Created subscription projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testUsesDlq-2018-08-09-00-07-56-692-events-5279369277619204319_beam_1202031162838761475 to topic projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testUsesDlq-2018-08-09-00-07-56-692-events-5279369277619204319. Note this subscription WILL NOT be deleted when the pipeline terminates Aug 09, 2018 12:08:02 AM org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription WARNING: Created subscription projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testUsesDlq-2018-08-09-00-07-56-992-events--3120200353608758826_beam_7978271719868417929 to topic projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testUsesDlq-2018-08-09-00-07-56-992-events--3120200353608758826. Note this subscription WILL NOT be deleted when the pipeline terminates Aug 09, 2018 12:08:17 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal pollForResultForDuration WARNING: (Will retry) Error while polling projects/apache-beam-testing/subscriptions/start-subscription--7656899140743596797 for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before operation could complete., cause=null} Aug 09, 2018 12:08:40 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal pollForResultForDuration WARNING: (Will retry) Error while polling projects/apache-beam-testing/subscriptions/result-subscription-3932499580299619815 for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before operation could complete., cause=null} Aug 09, 2018 12:08:55 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal pollForResultForDuration WARNING: (Will retry) Error while polling projects/apache-beam-testing/subscriptions/result-subscription-3932499580299619815 for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before operation could complete., cause=null} Aug 09, 2018 12:09:11 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal pollForResultForDuration WARNING: (Will retry) Error while polling projects/apache-beam-testing/subscriptions/result-subscription-3932499580299619815 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 Aug 09, 2018 12:09:22 AM org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription WARNING: Created subscription projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testSQLLimit-2018-08-09-00-09-18-820-events-2881399449057768568_beam_-3693124145572990465 to topic projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testSQLLimit-2018-08-09-00-09-18-820-events-2881399449057768568. Note this subscription WILL NOT be deleted when the pipeline terminates Gradle Test Executor 119 finished executing tests. > Task :beam-sdks-java-extensions-sql:integrationTest Finished generating test XML results (0.001 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 5,5,main]) completed. Took 3 mins 10.011 secs. :beam-sdks-java-extensions-sql:postCommit (Thread[Task worker for ':' Thread 5,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 5,5,main]) completed. Took 0.0 secs. FAILURE: Build completed with 3 failures. 1: Task failed with an exception. ----------- * What went wrong: Execution failed for task ':beam-sdks-java-extensions-protobuf:extractIncludeTestProto'. > Could not expand ZIP > '<https://builds.apache.org/job/beam_PostCommit_Java_GradleBuild/ws/src/sdks/java/core/build/libs/beam-sdks-java-core-2.7.0-SNAPSHOT-tests.jar'.> * 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. ============================================================================== 2: Task 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. ============================================================================== 3: Task failed with an exception. ----------- * What went wrong: Execution failed for task ':beam-sdks-java-io-elasticsearch-tests-2: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 14m 8s 697 actionable tasks: 692 executed, 5 from cache Publishing build scan... https://gradle.com/s/sm35b7o6cc254 Build step 'Invoke Gradle script' changed build result to FAILURE Build step 'Invoke Gradle script' marked build as failure