[ https://issues.apache.org/jira/browse/HIVE-21231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16801752#comment-16801752 ]
Hive QA commented on HIVE-21231: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12963731/HIVE-21231.02.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/16689/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/16689/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-16689/ Messages: {noformat} **** This message was trimmed, see log for full details **** + [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]] + export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + export PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m ' + ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m ' + export 'MAVEN_OPTS=-Xmx1g ' + MAVEN_OPTS='-Xmx1g ' + cd /data/hiveptest/working/ + tee /data/hiveptest/logs/PreCommit-HIVE-Build-16689/source-prep.txt + [[ false == \t\r\u\e ]] + mkdir -p maven ivy + [[ git = \s\v\n ]] + [[ git = \g\i\t ]] + [[ -z master ]] + [[ -d apache-github-source-source ]] + [[ ! -d apache-github-source-source/.git ]] + [[ ! -d apache-github-source-source ]] + date '+%Y-%m-%d %T.%3N' 2019-03-26 14:01:13.298 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 80998ad HIVE-21493: BuddyAllocator - Metrics count for allocated arenas wrong if preallocation is done (Olli Draese via Slim Bouguerra) + git clean -f -d + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 80998ad HIVE-21493: BuddyAllocator - Metrics count for allocated arenas wrong if preallocation is done (Olli Draese via Slim Bouguerra) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-03-26 14:01:14.589 + rm -rf ../yetus_PreCommit-HIVE-Build-16689 + mkdir ../yetus_PreCommit-HIVE-Build-16689 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-16689 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-16689/yetus + patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hiveptest/working/scratch/build.patch + [[ -f /data/hiveptest/working/scratch/build.patch ]] + chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh + /data/hiveptest/working/scratch/smart-apply-patch.sh /data/hiveptest/working/scratch/build.patch error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java: does not exist in index error: a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java: does not exist in index error: a/ql/src/test/results/clientnegative/subquery_scalar_multi_rows.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/interval_3.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/join43.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/join_merging.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/cross_prod_1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/groupby_groupingset_bug.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/semijoin.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/subquery_corr.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/subquery_in.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/subquery_notin.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/llap/subquery_select.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query23.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query24.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query30.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query32.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query44.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query54.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query6.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query65.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query72.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query81.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/spark/query92.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_ext_query1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query14.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query23.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query24.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query30.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query32.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query54.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query6.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query64.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query65.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query72.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query81.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/cbo_query92.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_ext_query1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query14.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query23.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query24.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query30.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query32.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query54.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query6.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query64.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query65.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query72.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query81.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query92.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/mv_query44.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query14.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query23.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query24.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query30.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query32.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query44.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query54.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query6.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query64.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query65.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query72.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query81.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/constraints/query92.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query1.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query14.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query23.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query24.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query30.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query32.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query44.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query54.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query6.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query64.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query65.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query72.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query81.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/perf/tez/query92.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/spark/join_merging.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/spark/semijoin.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/spark/subquery_in.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/spark/subquery_notin.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/spark/subquery_scalar.q.out: does not exist in index error: a/ql/src/test/results/clientpositive/spark/subquery_select.q.out: does not exist in index Going to apply patch with: git apply -p1 /data/hiveptest/working/scratch/build.patch:144: trailing whitespace. /data/hiveptest/working/scratch/build.patch:242: trailing whitespace. sort order: /data/hiveptest/working/scratch/build.patch:263: trailing whitespace. sort order: /data/hiveptest/working/scratch/build.patch:437: trailing whitespace. sort order: /data/hiveptest/working/scratch/build.patch:452: trailing whitespace. sort order: warning: squelched 187 whitespace errors warning: 192 lines add whitespace errors. + [[ maven == \m\a\v\e\n ]] + rm -rf /data/hiveptest/working/maven/org/apache/hive + mvn -B clean install -DskipTests -T 4 -q -Dmaven.repo.local=/data/hiveptest/working/maven protoc-jar: executing: [/tmp/protoc3272607089995479102.exe, --version] libprotoc 2.5.0 protoc-jar: executing: [/tmp/protoc3272607089995479102.exe, -I/data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/src/main/protobuf/org/apache/hadoop/hive/metastore, --java_out=/data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/target/generated-sources, /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-common/src/main/protobuf/org/apache/hadoop/hive/metastore/metastore.proto] ANTLR Parser Generator Version 3.5.2 protoc-jar: executing: [/tmp/protoc1212919513595845681.exe, --version] libprotoc 2.5.0 ANTLR Parser Generator Version 3.5.2 Output file /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-server/target/generated-sources/org/apache/hadoop/hive/metastore/parser/FilterParser.java does not exist: must build /data/hiveptest/working/apache-github-source-source/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/parser/Filter.g org/apache/hadoop/hive/metastore/parser/Filter.g log4j:WARN No appenders could be found for logger (DataNucleus.Persistence). log4j:WARN Please initialize the log4j system properly. DataNucleus Enhancer (version 4.1.17) for API "JDO" DataNucleus Enhancer completed with success for 41 classes. ANTLR Parser Generator Version 3.5.2 Output file /data/hiveptest/working/apache-github-source-source/ql/target/generated-sources/antlr3/org/apache/hadoop/hive/ql/parse/HiveLexer.java does not exist: must build /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g org/apache/hadoop/hive/ql/parse/HiveLexer.g Output file /data/hiveptest/working/apache-github-source-source/ql/target/generated-sources/antlr3/org/apache/hadoop/hive/ql/parse/HiveParser.java does not exist: must build /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g org/apache/hadoop/hive/ql/parse/HiveParser.g Output file /data/hiveptest/working/apache-github-source-source/ql/target/generated-sources/antlr3/org/apache/hadoop/hive/ql/parse/HintParser.java does not exist: must build /data/hiveptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/parse/HintParser.g org/apache/hadoop/hive/ql/parse/HintParser.g Generating vector expression code Generating vector expression test code Processing annotations Annotations processed Processing annotations No elements to process Processing annotations Annotations processed Processing annotations No elements to process Processing annotations Annotations processed Processing annotations No elements to process [ERROR] Failed to execute goal on project hive-hbase-handler: Could not resolve dependencies for project org.apache.hive:hive-hbase-handler:jar:4.0.0-SNAPSHOT: Failed to collect dependencies for [org.apache.hive:hive-exec:jar:4.0.0-SNAPSHOT (compile), commons-lang:commons-lang:jar:2.6 (compile), org.apache.hadoop:hadoop-common:jar:3.1.0 (compile?), org.apache.hadoop:hadoop-mapreduce-client-core:jar:3.1.0 (compile?), org.apache.hbase:hbase-hadoop2-compat:jar:2.0.0-alpha4 (compile), org.apache.hbase:hbase-client:jar:2.0.0-alpha4 (compile), org.apache.hbase:hbase-server:jar:2.0.0-alpha4 (compile), org.apache.hbase:hbase-mapreduce:jar:2.0.0-alpha4 (compile), org.apache.hbase:hbase-common:jar:2.0.0-alpha4 (compile), org.apache.hbase:hbase-hadoop-compat:jar:2.0.0-alpha4 (compile), org.apache.hadoop:hadoop-hdfs:jar:tests:3.1.0 (test), org.apache.hbase:hbase-hadoop2-compat:jar:tests:2.0.0-alpha4 (compile), org.apache.hbase:hbase-common:jar:tests:2.0.0-alpha4 (test), org.apache.hbase:hbase-server:jar:tests:2.0.0-alpha4 (test), org.apache.hbase:hbase-mapreduce:jar:tests:2.0.0-alpha4 (test), org.apache.hbase:hbase-hadoop-compat:jar:tests:2.0.0-alpha4 (test), org.eclipse.jetty:jetty-runner:jar:9.3.25.v20180904 (test), com.sun.jersey:jersey-servlet:jar:1.19 (test), org.apache.hadoop:hadoop-common:jar:tests:3.1.0 (test), junit:junit:jar:4.11 (test), org.apache.avro:avro:jar:1.8.2 (compile), org.slf4j:slf4j-api:jar:1.7.10 (compile), org.mockito:mockito-all:jar:1.10.19 (test)]: Failed to read artifact descriptor for org.glassfish.jersey.bundles.repackaged:jersey-guava:jar:2.25.1: Could not find artifact org.glassfish.jersey.bundles:project:pom:2.25.1 in datanucleus (http://www.datanucleus.org/downloads/maven2) -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException [ERROR] [ERROR] After correcting the problems, you can resume the build with the command [ERROR] mvn <goals> -rf :hive-hbase-handler + result=1 + '[' 1 -ne 0 ']' + rm -rf yetus_PreCommit-HIVE-Build-16689 + exit 1 ' {noformat} This message is automatically generated. ATTACHMENT ID: 12963731 - PreCommit-HIVE-Build > HiveJoinAddNotNullRule support for range predicates > --------------------------------------------------- > > Key: HIVE-21231 > URL: https://issues.apache.org/jira/browse/HIVE-21231 > Project: Hive > Issue Type: Improvement > Components: CBO > Reporter: Jesus Camacho Rodriguez > Assignee: Miklos Gergely > Priority: Major > Labels: newbie > Attachments: HIVE-21231.01.patch, HIVE-21231.02.patch > > > For instance, given the following query: > {code:sql} > SELECT t0.col0, t0.col1 > FROM > ( > SELECT col0, col1 FROM tab > ) AS t0 > INNER JOIN > ( > SELECT col0, col1 FROM tab > ) AS t1 > ON t0.col0 < t1.col0 AND t0.col1 > t1.col1 > {code} > we could still infer that col0 and col1 cannot be null for any of the inputs. > Currently we do not. -- This message was sent by Atlassian JIRA (v7.6.3#76005)