See
<https://builds.apache.org/job/beam_PostCommit_Java_GradleBuild/1181/display/redirect>
------------------------------------------
[...truncated 13.10 MB...]
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testSQLTypes STANDARD_ERROR
Aug 06, 2018 12:11:34 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_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a/
before loading them.
Aug 06, 2018 12:11:34 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_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a/5c073e4d-a530-42ef-a11d-df87af0ce49a.
Aug 06, 2018 12:11:35 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_08_06_00_11_28_710_7823074809177615890}
using job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0,
location=US, projectId=apache-beam-testing}, attempt 1
Aug 06, 2018 12:11:35 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0
Aug 06, 2018 12:11:35 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0,
location=US, projectId=apache-beam-testing} started
Aug 06, 2018 12:11:35 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0
Aug 06, 2018 12:11:36 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0
org.apache.beam.sdk.extensions.sql.PubsubToBigqueryIT > testSimpleInsert
STANDARD_ERROR
Aug 06, 2018 12:11:36 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubToBigqueryIT-testSimpleInsert-2018-08-06-00-11-29-294-events-1594789376880862377_beam_2736880595113543912
to topic
projects/apache-beam-testing/topics/integ-test-PubsubToBigqueryIT-testSimpleInsert-2018-08-06-00-11-29-294-events-1594789376880862377.
Note this subscription WILL NOT be deleted when the pipeline terminates
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testSQLTypes STANDARD_ERROR
Aug 06, 2018 12:11:38 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0,
location=US, projectId=apache-beam-testing} completed in state DONE
Aug 06, 2018 12:11:38 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqltypesjenkins080600113497fe643b_0e1153bfc45740c5a8c29b530648473a_d25a430bf8ab00fce0aa2bd470e37218_00001_00000-0,
location=US, projectId=apache-beam-testing} succeeded. Statistics:
{"creationTime":"1533514295217","endTime":"1533514296401","load":{"badRecords":"0","inputFileBytes":"243","inputFiles":"1","outputBytes":"82","outputRows":"1"},"startTime":"1533514295456"}
org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT >
testSelectsPayloadContent STANDARD_ERROR
Aug 06, 2018 12:11:38 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testSelectsPayloadContent-2018-08-06-00-11-30-396-events--3887310701352510795_beam_4889218329546535898
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testSelectsPayloadContent-2018-08-06-00-11-30-396-events--3887310701352510795.
Note this subscription WILL NOT be deleted when the pipeline terminates
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testSQLRead STANDARD_ERROR
Aug 06, 2018 12:11:38 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_06_00_11_38_926_4126661639270622326
Aug 06, 2018 12:11:39 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_06_00_11_39_099_7124405357551093829
Aug 06, 2018 12:11:39 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 06, 2018 12:11:39 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 06, 2018 12:11:39 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 06, 2018 12:11:39 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 06, 2018 12:11:39 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 06, 2018 12:11:39 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 06, 2018 12:11:39 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_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2/
before loading them.
Aug 06, 2018 12:11:39 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_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2/d4201739-a3cc-4086-8729-b8c277b6e3ff.
Aug 06, 2018 12:11:40 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_06_00_11_38_926_4126661639270622326}
using job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0,
location=US, projectId=apache-beam-testing}, attempt 1
Aug 06, 2018 12:11:40 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0
Aug 06, 2018 12:11:40 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0,
location=US, projectId=apache-beam-testing} started
Aug 06, 2018 12:11:40 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0
Aug 06, 2018 12:11:42 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0,
location=US, projectId=apache-beam-testing} completed in state DONE
Aug 06, 2018 12:11:42 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testsqlreadjenkins0806001139e6122b75_823408dbb36643fe98b390ef629ca0e2_7a93adcf66067a3642513c2072f0da72_00001_00000-0,
location=US, projectId=apache-beam-testing} succeeded. Statistics:
{"creationTime":"1533514300505","endTime":"1533514301763","load":{"badRecords":"0","inputFileBytes":"243","inputFiles":"1","outputBytes":"82","outputRows":"1"},"startTime":"1533514300858"}
Aug 06, 2018 12:11:42 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 06, 2018 12:11:42 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 06, 2018 12:11:42 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 06, 2018 12:11:43 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase executeExtract
INFO: Starting BigQuery extract job:
beam_job_7a36926c03fa41918dc9874dbdfbf783_bigqueryreadwriteit0testsqlreadjenkins08060011432bd00e09-extract
Aug 06, 2018 12:11:43 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_job_7a36926c03fa41918dc9874dbdfbf783_bigqueryreadwriteit0testsqlreadjenkins08060011432bd00e09-extract,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_job_7a36926c03fa41918dc9874dbdfbf783_bigqueryreadwriteit0testsqlreadjenkins08060011432bd00e09-extract
Aug 06, 2018 12:11:43 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_job_7a36926c03fa41918dc9874dbdfbf783_bigqueryreadwriteit0testsqlreadjenkins08060011432bd00e09-extract,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_job_7a36926c03fa41918dc9874dbdfbf783_bigqueryreadwriteit0testsqlreadjenkins08060011432bd00e09-extract
Aug 06, 2018 12:11:44 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_job_7a36926c03fa41918dc9874dbdfbf783_bigqueryreadwriteit0testsqlreadjenkins08060011432bd00e09-extract,
location=US, projectId=apache-beam-testing} completed in state DONE
Aug 06, 2018 12:11:44 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase executeExtract
INFO: BigQuery extract job completed:
beam_job_7a36926c03fa41918dc9874dbdfbf783_bigqueryreadwriteit0testsqlreadjenkins08060011432bd00e09-extract
Aug 06, 2018 12:11:44 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQuerySourceBase split
INFO: Extract job produced 1 files
Aug 06, 2018 12:11:45 AM org.apache.beam.sdk.io.FileBasedSource createReader
INFO: Matched 1 files for pattern
gs://temp-storage-for-end-to-end-tests/BigQueryExtractTemp/7a36926c03fa41918dc9874dbdfbf783/000000000000.avro
Aug 06, 2018 12:11:45 AM org.apache.beam.sdk.io.FileBasedSource
getEstimatedSizeBytes
INFO: Filepattern
gs://temp-storage-for-end-to-end-tests/BigQueryExtractTemp/7a36926c03fa41918dc9874dbdfbf783/000000000000.avro
matched 1 files with total size 738
org.apache.beam.sdk.extensions.sql.meta.provider.bigquery.BigQueryReadWriteIT >
testInsertSelect STANDARD_ERROR
Aug 06, 2018 12:11:46 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_06_00_11_46_127_1604244429361292753
Aug 06, 2018 12:11:46 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_06_00_11_46_318_8165727686278546984
Aug 06, 2018 12:11:46 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 06, 2018 12:11:46 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 06, 2018 12:11:46 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 06, 2018 12:11:47 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_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947/
before loading them.
Aug 06, 2018 12:11:47 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_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947/f1b01b98-6487-4b22-863e-17a9fcfab417.
Aug 06, 2018 12:11:47 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_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947/e28c93c6-3905-47a1-bf32-c4eaf954266c.
Aug 06, 2018 12:11:47 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_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947/24a3e31c-14a4-4c96-bc26-0d429cab873c.
Aug 06, 2018 12:11:47 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_06_00_11_46_318_8165727686278546984}
using job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0,
location=US, projectId=apache-beam-testing}, attempt 1
Aug 06, 2018 12:11:48 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl startJob
INFO: Started BigQuery job:
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0,
location=US, projectId=apache-beam-testing}.
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0
Aug 06, 2018 12:11:48 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0,
location=US, projectId=apache-beam-testing} started
Aug 06, 2018 12:11:48 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0
Aug 06, 2018 12:11:49 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: Still waiting for BigQuery job
beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0,
currently in status {"state":"RUNNING"}
bq show -j --format=prettyjson --project_id=apache-beam-testing
beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0
Aug 06, 2018 12:11:50 AM
org.apache.beam.sdk.io.gcp.bigquery.BigQueryServicesImpl$JobServiceImpl pollJob
INFO: BigQuery job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0,
location=US, projectId=apache-beam-testing} completed in state DONE
Aug 06, 2018 12:11:50 AM org.apache.beam.sdk.io.gcp.bigquery.WriteTables
load
INFO: Load job
{jobId=beam_load_bigqueryreadwriteit0testinsertselectjenkins08060011477c7049ff_d0311d1d435a4cc7b3126feb74141947_6f017e47fd584fbb739ceef48328ad10_00001_00000-0,
location=US, projectId=apache-beam-testing} succeeded. Statistics:
{"creationTime":"1533514307840","endTime":"1533514309334","load":{"badRecords":"0","inputFileBytes":"126","inputFiles":"3","outputBytes":"69","outputRows":"3"},"startTime":"1533514308153"}
Gradle Test Executor 120 finished executing tests.
Gradle Test Executor 122 finished executing tests.
> Task :beam-sdks-java-extensions-sql:integrationTest
org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT >
testSelectsPayloadContent STANDARD_ERROR
Aug 06, 2018 12:12:07 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription-2633522994039976259
for signal: Status{code=DEADLINE_EXCEEDED, description=deadline exceeded after
14998778533ns, cause=null}
org.apache.beam.sdk.extensions.sql.meta.provider.pubsub.PubsubJsonIT >
testUsesDlq STANDARD_ERROR
Aug 06, 2018 12:12:10 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 06, 2018 12:12:10 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 06, 2018 12:12:10 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 06, 2018 12:12:14 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testUsesDlq-2018-08-06-00-12-10-546-events-8671881304048744205_beam_-9078388197520601863
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testUsesDlq-2018-08-06-00-12-10-546-events-8671881304048744205.
Note this subscription WILL NOT be deleted when the pipeline terminates
Aug 06, 2018 12:12:16 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testUsesDlq-2018-08-06-00-12-10-260-events-1198041109582333567_beam_-4559699727125565732
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testUsesDlq-2018-08-06-00-12-10-260-events-1198041109582333567.
Note this subscription WILL NOT be deleted when the pipeline terminates
Aug 06, 2018 12:12:31 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/start-subscription--3615210237691720684
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
Aug 06, 2018 12:12:53 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription--1614796432287146348
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
Aug 06, 2018 12:13:08 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription--1614796432287146348
for signal: Status{code=DEADLINE_EXCEEDED, description=Deadline expired before
operation could complete., cause=null}
Aug 06, 2018 12:13:24 AM org.apache.beam.sdk.io.gcp.pubsub.TestPubsubSignal
pollForResultForDuration
WARNING: (Will retry) Error while polling
projects/apache-beam-testing/subscriptions/result-subscription--1614796432287146348
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 06, 2018 12:13:40 AM
org.apache.beam.sdk.io.gcp.pubsub.PubsubUnboundedSource createRandomSubscription
WARNING: Created subscription
projects/apache-beam-testing/subscriptions/integ-test-PubsubJsonIT-testSQLLimit-2018-08-06-00-13-36-931-events-4063057960798565381_beam_14883418922313826
to topic
projects/apache-beam-testing/topics/integ-test-PubsubJsonIT-testSQLLimit-2018-08-06-00-13-36-931-events-4063057960798565381.
Note this subscription WILL NOT be deleted when the pipeline terminates
Gradle Test Executor 121 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 4,5,main]) completed. Took 3 mins 15.883 secs.
:beam-sdks-java-extensions-sql:postCommit (Thread[Task worker for ':' Thread
4,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
4,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 14m 35s
709 actionable tasks: 704 executed, 5 from cache
Publishing build scan...
https://gradle.com/s/3gom3slro4d4g
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
