[ 
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)

Reply via email to