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

Josh Elser commented on HIVE-15708:
-----------------------------------

[~rusanu] had pinged me off-jira (as I'm behind some of  the changes in 
packaging in Avatica-1.9.0).

I think the errors that were being seen with .03 were related to duplicate 
avatica-core (non-shaded) and avatica(shaded) jars being included on the 
classpath. I've tweaked the .03 patch and uploaded a .04 with a fix.

I'm still seeing a test failure, but it seems like a legitimate test failure 
instead of a classpath issue :)

{noformat}
Running org.apache.hadoop.hive.cli.TestMinimrCliDriver
Tests run: 3, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 222.128 sec <<< 
FAILURE! - in org.apache.hadoop.hive.cli.TestMinimrCliDriver
testCliDriver[filter_cond_pushdown](org.apache.hadoop.hive.cli.TestMinimrCliDriver)
  Time elapsed: 3.371 sec  <<< FAILURE!
java.lang.AssertionError:
Unexpected exception java.lang.AssertionError: Client execution failed with 
error code = 10001 running

EXPLAIN
SELECT t1.key
FROM cbo_t1 t1
JOIN (
  SELECT t2.key
  FROM cbo_t2 t2
  JOIN (SELECT * FROM cbo_t3 t3 WHERE c_int=1) t3 ON t2.key=t3.c_int
  WHERE ((t2.key=t3.key) AND (t2.c_float + t3.c_float > 2)) OR
      ((t2.key=t3.key) AND (t2.c_int + t3.c_int > 2))) t4 ON 
t1.key=t4.keyfname=filter_cond_pushdown.q
See ./ql/target/tmp/log/hive.log or ./itests/qtest/target/tmp/log/hive.log, or 
check ./ql/target/surefire-reports or ./itests/qtest/target/surefire-reports/ 
for specific test cases logs.
        at org.junit.Assert.fail(Assert.java:88)
        at org.apache.hadoop.hive.ql.QTestUtil.failed(QTestUtil.java:2225)
        at 
org.apache.hadoop.hive.cli.control.CoreCliDriver.runTest(CoreCliDriver.java:176)
        at 
org.apache.hadoop.hive.cli.control.CliAdapter.runTest(CliAdapter.java:104)
        at 
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver(TestMinimrCliDriver.java:59)
{noformat}

With a corresponding:

{noformat}
2017-01-26T13:35:58,930 ERROR [6bc10e68-b722-4d5c-9b9e-a7baa9315e0d main] 
parse.CalcitePlanner: org.apache.hadoop.hive.ql.parse.SemanticException: Line 
5:5 Table not found 'cbo_t1'
  at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1989)
  at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1917)
  at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:10937)
  at 
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10988)
  at 
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:275)
  at 
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258)
  at 
org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:129)
  at 
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258)
  at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:513)
  at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1305)
  at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1445)
  at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1225)
  at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1215)
  at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:233)
  at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:184)
  at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:403)
  at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:336)
  at 
org.apache.hadoop.hive.ql.QTestUtil.executeClientInternal(QTestUtil.java:1373)
  at org.apache.hadoop.hive.ql.QTestUtil.executeClient(QTestUtil.java:1347)
  at 
org.apache.hadoop.hive.cli.control.CoreCliDriver.runTest(CoreCliDriver.java:173)
  at org.apache.hadoop.hive.cli.control.CliAdapter.runTest(CliAdapter.java:104)
  at 
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver(TestMinimrCliDriver.java:59)
{noformat}

> Upgrade calcite version to 1.11
> -------------------------------
>
>                 Key: HIVE-15708
>                 URL: https://issues.apache.org/jira/browse/HIVE-15708
>             Project: Hive
>          Issue Type: Task
>          Components: CBO, Logical Optimizer
>    Affects Versions: 2.2.0
>            Reporter: Ashutosh Chauhan
>            Assignee: Remus Rusanu
>         Attachments: HIVE-15708.01.patch, HIVE-15708.02.patch, 
> HIVE-15708.03.patch
>
>
> Currently we are on 1.10 Need to upgrade calcite version to 1.11



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

Reply via email to