hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14431) Recognize COALESCE as CASE and extend CASE simplification to cover more cases
Date Thu, 04 Aug 2016 23:07:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-14431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15408623#comment-15408623
] 

Hive QA commented on HIVE-14431:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12822143/HIVE-14431.patch

{color:red}ERROR:{color} -1 due to build exiting with an error

Test results: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/776/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/776/console
Test logs: http://ec2-204-236-174-241.us-west-1.compute.amazonaws.com/logs/PreCommit-HIVE-MASTER-Build-776/

Messages:
{noformat}
**** This message was trimmed, see log for full details ****
[INFO] Executing tasks

main:
    [mkdir] Created dir: /data/hive-ptest/working/apache-github-source-source/spark-client/target/tmp
    [mkdir] Created dir: /data/hive-ptest/working/apache-github-source-source/spark-client/target/warehouse
    [mkdir] Created dir: /data/hive-ptest/working/apache-github-source-source/spark-client/target/tmp/conf
     [copy] Copying 15 files to /data/hive-ptest/working/apache-github-source-source/spark-client/target/tmp/conf
[INFO] Executed tasks
[INFO] 
[INFO] --- maven-compiler-plugin:3.1:testCompile (default-testCompile) @ spark-client ---
[INFO] Compiling 5 source files to /data/hive-ptest/working/apache-github-source-source/spark-client/target/test-classes
[INFO] 
[INFO] --- maven-dependency-plugin:2.8:copy (copy-guava-14) @ spark-client ---
[INFO] Configured Artifact: com.google.guava:guava:14.0.1:jar
[INFO] Copying guava-14.0.1.jar to /data/hive-ptest/working/apache-github-source-source/spark-client/target/dependency/guava-14.0.1.jar
[INFO] 
[INFO] --- maven-surefire-plugin:2.16:test (default-test) @ spark-client ---
[INFO] Tests are skipped.
[INFO] 
[INFO] --- maven-jar-plugin:2.2:jar (default-jar) @ spark-client ---
[INFO] Building jar: /data/hive-ptest/working/apache-github-source-source/spark-client/target/spark-client-2.2.0-SNAPSHOT.jar
[INFO] 
[INFO] --- maven-site-plugin:3.3:attach-descriptor (attach-descriptor) @ spark-client ---
[INFO] 
[INFO] --- maven-install-plugin:2.4:install (default-install) @ spark-client ---
[INFO] Installing /data/hive-ptest/working/apache-github-source-source/spark-client/target/spark-client-2.2.0-SNAPSHOT.jar
to /data/hive-ptest/working/maven/org/apache/hive/spark-client/2.2.0-SNAPSHOT/spark-client-2.2.0-SNAPSHOT.jar
[INFO] Installing /data/hive-ptest/working/apache-github-source-source/spark-client/pom.xml
to /data/hive-ptest/working/maven/org/apache/hive/spark-client/2.2.0-SNAPSHOT/spark-client-2.2.0-SNAPSHOT.pom
[INFO]                                                                         
[INFO] ------------------------------------------------------------------------
[INFO] Building Hive Query Language 2.2.0-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO] 
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ hive-exec ---
[INFO] Deleting /data/hive-ptest/working/apache-github-source-source/ql/target
[INFO] Deleting /data/hive-ptest/working/apache-github-source-source/ql (includes = [datanucleus.log,
derby.log], excludes = [])
[INFO] 
[INFO] --- maven-enforcer-plugin:1.3.1:enforce (enforce-no-snapshots) @ hive-exec ---
[INFO] 
[INFO] --- maven-antrun-plugin:1.7:run (generate-sources) @ hive-exec ---
[INFO] Executing tasks

main:
    [mkdir] Created dir: /data/hive-ptest/working/apache-github-source-source/ql/target/generated-sources/java/org/apache/hadoop/hive/ql/exec/vector/expressions/gen
    [mkdir] Created dir: /data/hive-ptest/working/apache-github-source-source/ql/target/generated-sources/java/org/apache/hadoop/hive/ql/exec/vector/expressions/aggregates/gen
    [mkdir] Created dir: /data/hive-ptest/working/apache-github-source-source/ql/target/generated-test-sources/java/org/apache/hadoop/hive/ql/exec/vector/expressions/gen
Generating vector expression code
Generating vector expression test code
[INFO] Executed tasks
[INFO] 
[INFO] --- build-helper-maven-plugin:1.8:add-source (add-source) @ hive-exec ---
[INFO] Source directory: /data/hive-ptest/working/apache-github-source-source/ql/src/gen/thrift/gen-javabean
added.
[INFO] Source directory: /data/hive-ptest/working/apache-github-source-source/ql/target/generated-sources/java
added.
[INFO] 
[INFO] --- antlr3-maven-plugin:3.4:antlr (default) @ hive-exec ---
[INFO] ANTLR: Processing source directory /data/hive-ptest/working/apache-github-source-source/ql/src/java
ANTLR Parser Generator  Version 3.4
org/apache/hadoop/hive/ql/parse/HiveLexer.g
org/apache/hadoop/hive/ql/parse/HiveParser.g
[INFO] 
[INFO] --- maven-remote-resources-plugin:1.5:process (default) @ hive-exec ---
[INFO] 
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ hive-exec ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 4 resources
[INFO] Copying 3 resources
[INFO] 
[INFO] --- maven-antrun-plugin:1.7:run (define-classpath) @ hive-exec ---
[INFO] Executing tasks

main:
[INFO] Executed tasks
[INFO] 
[INFO] --- maven-compiler-plugin:3.1:compile (default-compile) @ hive-exec ---
[INFO] Compiling 2653 source files to /data/hive-ptest/working/apache-github-source-source/ql/target/classes
[INFO] -------------------------------------------------------------
[ERROR] COMPILATION ERROR : 
[INFO] -------------------------------------------------------------
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java:[130,40]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: package org.apache.hadoop.hive.metastore
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[22,40]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: package org.apache.hadoop.hive.metastore
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java:[168,11]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: class org.apache.hadoop.hive.ql.metadata.Hive
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java:[3472,23]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: class org.apache.hadoop.hive.ql.metadata.Hive
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbLockManager.java:[21,40]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: package org.apache.hadoop.hive.metastore
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[64,11]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: class org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[89,30]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: class org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[110,18]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: class org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbLockManager.java:[56,11]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: class org.apache.hadoop.hive.ql.lockmgr.DbLockManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbLockManager.java:[60,17]
cannot find symbol
  symbol:   class SynchronizedMetaStoreClient
  location: class org.apache.hadoop.hive.ql.lockmgr.DbLockManager
[INFO] 10 errors 
[INFO] -------------------------------------------------------------
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO] 
[INFO] Hive .............................................. SUCCESS [1.666s]
[INFO] Hive Shims Common ................................. SUCCESS [3.660s]
[INFO] Hive Shims 0.23 ................................... SUCCESS [1.955s]
[INFO] Hive Shims Scheduler .............................. SUCCESS [0.701s]
[INFO] Hive Shims ........................................ SUCCESS [0.469s]
[INFO] Hive Storage API .................................. SUCCESS [1.144s]
[INFO] Hive ORC .......................................... SUCCESS [4.282s]
[INFO] Hive Common ....................................... SUCCESS [3.947s]
[INFO] Hive Service RPC .................................. SUCCESS [3.256s]
[INFO] Hive Serde ........................................ SUCCESS [4.929s]
[INFO] Hive Metastore .................................... SUCCESS [19.637s]
[INFO] Hive Ant Utilities ................................ SUCCESS [0.382s]
[INFO] Hive Llap Common .................................. SUCCESS [3.319s]
[INFO] Hive Llap Client .................................. SUCCESS [1.196s]
[INFO] Hive Llap Tez ..................................... SUCCESS [1.385s]
[INFO] Spark Remote Client ............................... SUCCESS [2.392s]
[INFO] Hive Query Language ............................... FAILURE [17.239s]
[INFO] Hive Llap Server .................................. SKIPPED
[INFO] Hive Service ...................................... SKIPPED
[INFO] Hive Accumulo Handler ............................. SKIPPED
[INFO] Hive JDBC ......................................... SKIPPED
[INFO] Hive Beeline ...................................... SKIPPED
[INFO] Hive CLI .......................................... SKIPPED
[INFO] Hive Contrib ...................................... SKIPPED
[INFO] Hive HBase Handler ................................ SKIPPED
[INFO] Hive HCatalog ..................................... SKIPPED
[INFO] Hive HCatalog Core ................................ SKIPPED
[INFO] Hive HCatalog Pig Adapter ......................... SKIPPED
[INFO] Hive HCatalog Server Extensions ................... SKIPPED
[INFO] Hive HCatalog Webhcat Java Client ................. SKIPPED
[INFO] Hive HCatalog Webhcat ............................. SKIPPED
[INFO] Hive HCatalog Streaming ........................... SKIPPED
[INFO] Hive HPL/SQL ...................................... SKIPPED
[INFO] Hive HWI .......................................... SKIPPED
[INFO] Hive Llap External Client ......................... SKIPPED
[INFO] Hive Shims Aggregator ............................. SKIPPED
[INFO] Hive TestUtils .................................... SKIPPED
[INFO] Hive Packaging .................................... SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1:12.323s
[INFO] Finished at: Thu Aug 04 23:07:00 UTC 2016
[INFO] Final Memory: 131M/915M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile
(default-compile) on project hive-exec: Compilation failure: Compilation failure:
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java:[130,40]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: package org.apache.hadoop.hive.metastore
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[22,40]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: package org.apache.hadoop.hive.metastore
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java:[168,11]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: class org.apache.hadoop.hive.ql.metadata.Hive
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java:[3472,23]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: class org.apache.hadoop.hive.ql.metadata.Hive
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbLockManager.java:[21,40]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: package org.apache.hadoop.hive.metastore
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[64,11]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: class org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[89,30]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: class org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbTxnManager.java:[110,18]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: class org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbLockManager.java:[56,11]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: class org.apache.hadoop.hive.ql.lockmgr.DbLockManager
[ERROR] /data/hive-ptest/working/apache-github-source-source/ql/src/java/org/apache/hadoop/hive/ql/lockmgr/DbLockManager.java:[60,17]
cannot find symbol
[ERROR] symbol:   class SynchronizedMetaStoreClient
[ERROR] location: class org.apache.hadoop.hive.ql.lockmgr.DbLockManager
[ERROR] -> [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/MojoFailureException
[ERROR] 
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR]   mvn <goals> -rf :hive-exec
+ exit 1
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12822143 - PreCommit-HIVE-MASTER-Build

> Recognize COALESCE as CASE and extend CASE simplification to cover more cases
> -----------------------------------------------------------------------------
>
>                 Key: HIVE-14431
>                 URL: https://issues.apache.org/jira/browse/HIVE-14431
>             Project: Hive
>          Issue Type: Improvement
>          Components: CBO
>    Affects Versions: 2.2.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-14431.patch
>
>
> Transform:
> {code}
> (COALESCE(a, '')  = '') OR
>            (a = 'A' AND b = c)  OR
>            (a = 'B' AND b = d) OR
>            (a = 'C' AND b = e) OR
>            (a = 'D' AND b = f) OR
>            (a = 'E' AND b = g) OR
>            (a = 'F' AND b = h)
> {code}
> into:
> {code}
> (a='') OR
>            (a is null) OR
>            (a = 'A' AND b = c)  OR
>            (a = 'B' AND b = d) OR
>            (a = 'C' AND b = e) OR
>            (a = 'D' AND b = f) OR
>            (a = 'E' AND b = g) OR
>            (a = 'F' AND b = h)
> {code}
> With complex queries, this will lead us to factor more predicates that could be pushed
to the TS.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message