You are viewing a plain text version of this content. The canonical link for it is here.
Posted to builds@beam.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2022/05/22 04:40:08 UTC

Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2891

See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2891/display/redirect>

Changes:


------------------------------------------
[...truncated 102.61 KB...]
> Task :sdks:java:extensions:sql:perf-tests:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 22, 2022 4:38:04 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 22, 2022 4:38:04 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:04 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:05 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 22, 2022 4:38:05 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 4:38:05 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 4:38:05 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 4:38:12 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 22, 2022 4:38:12 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:13 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts
> Task :sdks:java:extensions:sql:shell:distTar
> Task :runners:flink:1.14:job-server:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 4:38:13 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 22, 2022 4:38:13 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:13 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:13 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 22, 2022 4:38:13 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 4:38:14 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 4:38:14 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[3, Baz]: is from Wonderland
[4, Grault]: is from Wonderland
[1, Foo]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:io:hcatalog:compileJava
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :sdks:java:io:hcatalog:compileJava FAILED
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0
      > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
         > Could not get resource 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'.
            > Could not GET 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'. Received status code 504 from server: Gateway Time-out

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 41s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/54uykvgd4v6cq

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Jenkins build is back to normal : beam_PreCommit_SQL_Java11_Cron #2901

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2901/display/redirect?page=changes>


---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2900

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2900/display/redirect>

Changes:


------------------------------------------
[...truncated 103.52 KB...]
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 24, 2022 10:37:51 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 24, 2022 10:37:51 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 10:37:52 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 10:37:52 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 24, 2022 10:37:52 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 24, 2022 10:37:52 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 24, 2022 10:37:52 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts
> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 24, 2022 10:38:00 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 24, 2022 10:38:00 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$1], name=[$0])
  LogicalFilter(condition=[=($2, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.14:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 24, 2022 10:38:00 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t2, $t3)], id=[$t1], name=[$t0], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 10:38:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 24, 2022 10:38:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 10:38:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 10:38:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 24, 2022 10:38:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$2], EXPR$1=[||('order id:', CAST($0):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($2, 'Grault')])
    LogicalJoin(condition=[=($1, $3)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 24, 2022 10:38:01 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t0):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t2], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($1, $3)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 24, 2022 10:38:02 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[4, Grault]: is from Wonderland
[3, Baz]: is from Wonderland
[1, Foo]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not find org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Searched in the following locations:
       - <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/io/hcatalog/offline-repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom>
       - https://repo.maven.apache.org/maven2/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - file:/home/jenkins/.m2/repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://oss.sonatype.org/content/repositories/staging/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/snapshots/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/content/repositories/releases/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 27s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/me7rgs52nqqe6

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2899

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2899/display/redirect?page=changes>

Changes:

[noreply] [BEAM-14486] Document pubsubio & fix its behavior. (#17709)

[noreply] [BEAM-14489] Remove non-SDF version of TextIO. (#17712)


------------------------------------------
[...truncated 103.67 KB...]
> Task :sdks:java:testing:tpcds:check UP-TO-DATE
> Task :sdks:java:testing:tpcds:build
> Task :sdks:java:testing:tpcds:buildDependents
> Task :sdks:java:testing:nexmark:test FROM-CACHE
> Task :sdks:java:testing:nexmark:check UP-TO-DATE
> Task :sdks:java:testing:nexmark:build
> Task :sdks:java:testing:nexmark:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 24, 2022 4:37:48 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 24, 2022 4:37:48 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 4:37:49 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 4:37:49 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 24, 2022 4:37:49 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 24, 2022 4:37:49 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 24, 2022 4:37:49 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts
> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 24, 2022 4:37:56 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 24, 2022 4:37:57 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 4:37:57 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :runners:flink:1.12:job-server:startScripts
> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.14:job-server:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 24, 2022 4:37:57 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 24, 2022 4:37:57 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 4:37:57 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 24, 2022 4:37:58 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 24, 2022 4:37:58 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 24, 2022 4:37:58 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 24, 2022 4:37:58 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[1, Foo]: is from Wonderland
[4, Grault]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not find org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Searched in the following locations:
       - <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/io/hcatalog/offline-repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom>
       - https://repo.maven.apache.org/maven2/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - file:/home/jenkins/.m2/repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://oss.sonatype.org/content/repositories/staging/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/snapshots/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/content/repositories/releases/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 17s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/ln2zroj5kcldq

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2898

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2898/display/redirect?page=changes>

Changes:

[noreply] [BEAM-14494] Tag rc dockre container with format ${RELEASE}rc${RC_NUM}

[noreply] [BEAM-11578] Fix TypeError in dataflow_metrics has 0 distribution sum

[noreply] [BEAM-14499] Step global, unbounded side input case back to warning

[noreply] [BEAM-14484] Step back unexpected primary handling to warnings (#17724)


------------------------------------------
[...truncated 103.60 KB...]
> Task :sdks:java:testing:nexmark:buildDependents
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 23, 2022 10:37:52 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 23, 2022 10:37:53 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:37:53 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:37:53 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 23, 2022 10:37:53 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 10:37:54 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 10:37:54 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 10:38:01 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 23, 2022 10:38:01 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :sdks:java:extensions:sql:shell:distTar
> Task :runners:flink:1.14:job-server:startScripts
> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 10:38:01 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:02 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 23, 2022 10:38:02 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:02 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:02 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 23, 2022 10:38:02 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 10:38:02 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 10:38:02 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[4, Grault]: is from Wonderland
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not find org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Searched in the following locations:
       - <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/io/hcatalog/offline-repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom>
       - https://repo.maven.apache.org/maven2/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - file:/home/jenkins/.m2/repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://oss.sonatype.org/content/repositories/staging/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/snapshots/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/content/repositories/releases/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 22s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/jsemrd73ldqfa

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2897

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2897/display/redirect>

Changes:


------------------------------------------
[...truncated 103.66 KB...]
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 23, 2022 4:38:07 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 23, 2022 4:38:07 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:07 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:08 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 23, 2022 4:38:08 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 4:38:08 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 4:38:08 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts
> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.14:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 4:38:16 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 23, 2022 4:38:17 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 4:38:17 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:17 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 23, 2022 4:38:18 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:18 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:18 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 23, 2022 4:38:18 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 4:38:18 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 4:38:19 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[3, Baz]: is from Wonderland
[1, Foo]: is from Wonderland
[4, Grault]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not find org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Searched in the following locations:
       - <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/io/hcatalog/offline-repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom>
       - https://repo.maven.apache.org/maven2/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - file:/home/jenkins/.m2/repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://oss.sonatype.org/content/repositories/staging/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/snapshots/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/content/repositories/releases/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 42s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/rvun7jxdoring

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2896

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2896/display/redirect?page=changes>

Changes:

[noreply] Add clarification on Filter transform's input function to pydoc.

[noreply] [BEAM-14367]Flaky timeout in


------------------------------------------
[...truncated 103.63 KB...]
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 23, 2022 10:38:02 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 23, 2022 10:38:02 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:03 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:03 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 23, 2022 10:38:03 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 10:38:03 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 10:38:03 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 10:38:10 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 23, 2022 10:38:10 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:11 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:11 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`

> Task :runners:flink:1.14:job-server:startScripts
> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts
> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 10:38:11 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:11 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 10:38:11 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 23, 2022 10:38:11 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 10:38:12 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 10:38:12 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[3, Baz]: is from Wonderland
[4, Grault]: is from Wonderland
[1, Foo]: is from Wonderland

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not find org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Searched in the following locations:
       - <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/ws/src/sdks/java/io/hcatalog/offline-repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom>
       - https://repo.maven.apache.org/maven2/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - file:/home/jenkins/.m2/repository/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://oss.sonatype.org/content/repositories/staging/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/snapshots/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
       - https://repository.apache.org/content/repositories/releases/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 33s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/ybaspl54qmzfm

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2895

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2895/display/redirect>

Changes:


------------------------------------------
[...truncated 102.38 KB...]
> Task :sdks:java:testing:nexmark:buildDependents
> Task :sdks:java:extensions:sql:perf-tests:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 23, 2022 4:38:08 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 23, 2022 4:38:08 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:09 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:09 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 23, 2022 4:38:09 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 4:38:09 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 23, 2022 4:38:10 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runBasicExample
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts
> Task :runners:flink:1.14:job-server:startScripts
> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts
> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 4:38:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 23, 2022 4:38:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:18 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 23, 2022 4:38:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build
> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 23, 2022 4:38:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 23, 2022 4:38:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 23, 2022 4:38:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 4:38:19 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 23, 2022 4:38:20 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[4, Grault]: is from Wonderland
[1, Foo]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :sdks:java:io:hcatalog:compileJava
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :sdks:java:io:hcatalog:compileJava FAILED
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0
      > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
         > Could not get resource 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'.
            > Could not GET 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'. Received status code 504 from server: Gateway Time-out

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 39s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/naax7trnuwh3o

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2894

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2894/display/redirect>

Changes:


------------------------------------------
[...truncated 103.36 KB...]
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 22, 2022 10:38:04 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 22, 2022 10:38:04 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:04 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 22, 2022 10:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 10:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 10:38:05 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [3, row, 3.0]
PCOLLECTION: [2, row, 2.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runBasicExample
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 10:38:12 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 22, 2022 10:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :runners:flink:1.14:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts
> Task :runners:flink:1.13:job-server:startScripts
> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 10:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 22, 2022 10:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 22, 2022 10:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 10:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 10:38:14 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[1, Foo]: is from Wonderland
[4, Grault]: is from Wonderland
[3, Baz]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:io:hcatalog:compileJava
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :sdks:java:io:hcatalog:compileJava FAILED
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0
      > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
         > Could not get resource 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'.
            > Could not GET 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'.
               > Read timed out

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 34s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/odhnbplxfxpj4

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2893

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2893/display/redirect>

Changes:


------------------------------------------
[...truncated 102.61 KB...]
> Task :sdks:java:extensions:sql:perf-tests:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 22, 2022 4:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 22, 2022 4:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 22, 2022 4:38:05 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 4:38:06 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 4:38:06 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 4:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 22, 2022 4:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:13 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :runners:flink:1.13:job-server:startScripts
> Task :runners:flink:1.12:job-server:startScripts
> Task :runners:flink:1.14:job-server:startScripts
> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 4:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 22, 2022 4:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 4:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 22, 2022 4:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 4:38:14 PM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 4:38:15 PM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform
[4, Grault]: is from Wonderland
[3, Baz]: is from Wonderland
[1, Foo]: is from Wonderland

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[3]: total customers in Wonderland
[Grault, order id:7]: ordered by 'Grault'
[Grault, order id:8]: ordered by 'Grault'

> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:io:hcatalog:compileJava
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :sdks:java:io:hcatalog:compileJava FAILED
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0
      > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
         > Could not get resource 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'.
            > Could not GET 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'. Received status code 504 from server: Gateway Time-out

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 40s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/fdm6l3dl4lztq

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org


Build failed in Jenkins: beam_PreCommit_SQL_Java11_Cron #2892

Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://ci-beam.apache.org/job/beam_PreCommit_SQL_Java11_Cron/2892/display/redirect>

Changes:


------------------------------------------
[...truncated 102.85 KB...]
> Task :sdks:java:extensions:sql:perf-tests:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:perf-tests:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:perf-tests:test NO-SOURCE
> Task :sdks:java:extensions:sql:perf-tests:check UP-TO-DATE
> Task :sdks:java:extensions:sql:perf-tests:build
> Task :sdks:java:extensions:sql:perf-tests:buildDependents

> Task :sdks:java:extensions:sql:runBasicExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:jdbc:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:compileTestJava FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:packageTests
> Task :sdks:java:extensions:sql:jdbc:assemble
> Task :sdks:java:extensions:sql:jdbc:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:jdbc:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:checkstyleTest FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:shadowJar FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:compileTestJava NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:testClasses UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:packageTests
> Task :sdks:java:extensions:sql:expansion-service:assemble
> Task :sdks:java:extensions:sql:expansion-service:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:analyzeTestClassesDependencies SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:checkstyleTest NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:javadoc FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsMain FROM-CACHE
> Task :sdks:java:extensions:sql:expansion-service:spotbugsTest SKIPPED
> Task :sdks:java:extensions:sql:expansion-service:test NO-SOURCE
> Task :sdks:java:extensions:sql:expansion-service:check UP-TO-DATE
> Task :sdks:java:extensions:sql:expansion-service:build

> Task :sdks:java:extensions:sql:runBasicExample
May 22, 2022 10:38:06 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`c1`, `PCOLLECTION`.`c2`, `PCOLLECTION`.`c3`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`c1` > 1
May 22, 2022 10:38:07 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(c1=[$0], c2=[$1], c3=[$2])
  LogicalFilter(condition=[>($0, 1)])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:07 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=[1], expr#4=[>($t0, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:07 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `CASE1_RESULT`.`c2`, SUM(`CASE1_RESULT`.`c3`)
FROM `beam`.`CASE1_RESULT` AS `CASE1_RESULT`
GROUP BY `CASE1_RESULT`.`c2`
May 22, 2022 10:38:07 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{0}], EXPR$1=[SUM($1)])
  LogicalProject(c2=[$1], c3=[$2])
    BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 10:38:08 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{1}], EXPR$1=[SUM($2)])
  BeamIOSourceRel(table=[[beam, CASE1_RESULT]])

May 22, 2022 10:38:08 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: log_result, SqlTransform
PCOLLECTION: [2, row, 2.0]
PCOLLECTION: [3, row, 3.0]
CASE1_RESULT: [row, 5.0]

> Task :sdks:java:extensions:sql:jdbc:shadowTestJar FROM-CACHE

> Task :sdks:java:extensions:sql:runPojoExample
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-jdk14/1.7.30/d35953dd2fe54ebe39fdf18cfd82fe6eb35b25ed/slf4j-jdk14-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/jenkins/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-log4j12/1.7.30/c21f55139d8141d2231214fb1feaf50a1edca95e/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]

> Task :sdks:java:extensions:sql:shell:startScripts

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 10:38:15 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `PCOLLECTION`.`id`, `PCOLLECTION`.`name`
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
WHERE `PCOLLECTION`.`countryOfResidence` = 'Wonderland'
May 22, 2022 10:38:15 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(id=[$2], name=[$1])
  LogicalFilter(condition=[=($0, 'Wonderland')])
    BeamIOSourceRel(table=[[beam, PCOLLECTION]])


> Task :runners:flink:1.12:job-server:startScripts
> Task :runners:flink:1.14:job-server:startScripts
> Task :runners:flink:1.13:job-server:startScripts
> Task :sdks:java:extensions:sql:shell:distTar

> Task :sdks:java:extensions:sql:runPojoExample
May 22, 2022 10:38:15 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Wonderland':VARCHAR], expr#4=[=($t0, $t3)], id=[$t2], name=[$t1], $condition=[$t4])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:16 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT COUNT(`PCOLLECTION`.`id`)
FROM `beam`.`PCOLLECTION` AS `PCOLLECTION`
May 22, 2022 10:38:16 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalAggregate(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:16 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamAggregationRel(group=[{}], EXPR$0=[COUNT()])
  BeamIOSourceRel(table=[[beam, PCOLLECTION]])

May 22, 2022 10:38:16 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQL:
SELECT `customers`.`name`, 'order id:' || CAST(`orders`.`id` AS VARCHAR)
FROM `beam`.`orders` AS `orders`
INNER JOIN `beam`.`customers` AS `customers` ON `orders`.`customerId` = `customers`.`id`
WHERE `customers`.`name` = 'Grault'
May 22, 2022 10:38:16 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: SQLPlan>
LogicalProject(name=[$3], EXPR$1=[||('order id:', CAST($1):VARCHAR NOT NULL)])
  LogicalFilter(condition=[=($3, 'Grault')])
    LogicalJoin(condition=[=($0, $4)], joinType=[inner])
      BeamIOSourceRel(table=[[beam, orders]])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 10:38:16 AM org.apache.beam.sdk.extensions.sql.impl.CalciteQueryPlanner convertToBeamRel
INFO: BEAMPlan>
BeamCalcRel(expr#0..4=[{inputs}], expr#5=['order id:'], expr#6=[CAST($t1):VARCHAR NOT NULL], expr#7=[||($t5, $t6)], name=[$t3], EXPR$1=[$t7])
  BeamCoGBKJoinRel(condition=[=($0, $4)], joinType=[inner])
    BeamIOSourceRel(table=[[beam, orders]])
    BeamCalcRel(expr#0..2=[{inputs}], expr#3=['Grault':VARCHAR], expr#4=[=($t1, $t3)], proj#0..2=[{exprs}], $condition=[$t4])
      BeamIOSourceRel(table=[[beam, customers]])

May 22, 2022 10:38:17 AM org.apache.beam.sdk.Pipeline validate
WARNING: The following transforms do not have stable unique names: Create.Values, MapElements, SqlTransform

> Task :sdks:java:extensions:sql:jdbc:test FROM-CACHE
> Task :sdks:java:extensions:sql:jdbc:check UP-TO-DATE
> Task :sdks:java:extensions:sql:jdbc:build

> Task :sdks:java:extensions:sql:runPojoExample
[3, Baz]: is from Wonderland
[1, Foo]: is from Wonderland
[4, Grault]: is from Wonderland
[3]: total customers in Wonderland
[Grault, order id:8]: ordered by 'Grault'
[Grault, order id:7]: ordered by 'Grault'

> Task :runners:flink:1.13:job-server:distTar
> Task :runners:flink:1.12:job-server:distTar
> Task :runners:flink:1.14:job-server:distTar
> Task :sdks:java:io:hcatalog:compileJava
> Task :sdks:java:extensions:sql:shell:distZip
> Task :sdks:java:extensions:sql:shell:assemble
> Task :sdks:java:extensions:sql:shell:analyzeClassesDependencies FROM-CACHE
> Task :sdks:java:extensions:sql:shell:analyzeDependencies UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:test NO-SOURCE
> Task :sdks:java:extensions:sql:shell:check UP-TO-DATE
> Task :sdks:java:extensions:sql:shell:build
> Task :sdks:java:extensions:sql:shell:buildDependents
> Task :sdks:java:extensions:sql:jdbc:buildDependents
> Task :runners:flink:1.13:job-server:distZip
> Task :runners:flink:1.12:job-server:distZip
> Task :runners:flink:1.14:job-server:distZip
> Task :runners:flink:1.12:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.13:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.14:job-server:shadowJar FROM-CACHE
> Task :runners:flink:1.12:job-server:startShadowScripts
> Task :runners:flink:1.13:job-server:startShadowScripts
> Task :runners:flink:1.12:job-server:shadowDistTar
> Task :runners:flink:1.13:job-server:shadowDistTar
> Task :sdks:java:io:hcatalog:compileJava FAILED
> Task :runners:flink:1.14:job-server:startShadowScripts
> Task :runners:flink:1.14:job-server:shadowDistTar
> Task :runners:flink:1.12:job-server:shadowDistZip
> Task :runners:flink:1.12:job-server:assemble
> Task :runners:flink:1.12:job-server:test NO-SOURCE
> Task :runners:flink:1.12:job-server:check UP-TO-DATE
> Task :runners:flink:1.12:job-server:build
> Task :runners:flink:1.12:job-server:buildDependents
> Task :runners:flink:1.13:job-server:shadowDistZip
> Task :runners:flink:1.13:job-server:assemble
> Task :runners:flink:1.13:job-server:test NO-SOURCE
> Task :runners:flink:1.13:job-server:check UP-TO-DATE
> Task :runners:flink:1.13:job-server:build
> Task :runners:flink:1.13:job-server:buildDependents
> Task :runners:flink:1.14:job-server:shadowDistZip
> Task :runners:flink:1.14:job-server:assemble
> Task :runners:flink:1.14:job-server:test NO-SOURCE
> Task :runners:flink:1.14:job-server:check UP-TO-DATE
> Task :runners:flink:1.14:job-server:build
> Task :runners:flink:1.14:job-server:buildDependents
> Task :sdks:java:extensions:sql:expansion-service:buildDependents
> Task :sdks:java:extensions:sql:zetasql:buildDependents

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':sdks:java:io:hcatalog:compileJava'.
> Could not resolve all files for configuration ':sdks:java:io:hcatalog:compileClasspath'.
   > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
     Required by:
         project :sdks:java:io:hcatalog > org.apache.hive:hive-exec:2.1.0 > org.apache.calcite:calcite-core:1.6.0
      > Could not resolve org.pentaho:pentaho-aggdesigner-algorithm:5.1.5-jhyde.
         > Could not get resource 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'.
            > Could not GET 'https://public.nexus.pentaho.org/repository/proxy-public-3rd-party-release/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom'.
               > Read timed out

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --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 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.4/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 2m 41s
247 actionable tasks: 123 executed, 124 from cache

Publishing build scan...
https://gradle.com/s/veo44ly4exlri

Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure

---------------------------------------------------------------------
To unsubscribe, e-mail: builds-unsubscribe@beam.apache.org
For additional commands, e-mail: builds-help@beam.apache.org