[ https://issues.apache.org/jira/browse/HIVE-18585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16345812#comment-16345812 ]
Ashutosh Chauhan commented on HIVE-18585: ----------------------------------------- {code} 2018-01-29T23:22:43,564 ERROR [46b8c1ed-6d26-449b-a7a1-a7d6fe0b9afe HiveServer2-Handler-Pool: Thread-91]: parse.CalcitePlanner (:()) - CBO failed, skipping CBO. java.lang.NullPointerException: null at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:212) ~[guava-19.0.jar:?] at org.apache.calcite.rex.RexCall.<init>(RexCall.java:59) ~[calcite-core-1.15.0.jar:1.15.0] at org.apache.calcite.rex.RexBuilder.makeCall(RexBuilder.java:249) ~[calcite-core-1.15.0.jar:1.15.0] at org.apache.hadoop.hive.ql.optimizer.calcite.translator.RexNodeConverter.convert(RexNodeConverter.java:340) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.optimizer.calcite.translator.RexNodeConverter.convert(RexNodeConverter.java:173) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.optimizer.calcite.translator.RexNodeConverter.convert(RexNodeConverter.java:316) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.optimizer.calcite.translator.RexNodeConverter.convert(RexNodeConverter.java:173) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.optimizer.calcite.translator.RexNodeConverter.convert(RexNodeConverter.java:316) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.optimizer.calcite.translator.RexNodeConverter.convert(RexNodeConverter.java:173) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.genGBRelNode(CalcitePlanner.java:3032) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.genGBLogicalPlan(CalcitePlanner.java:3384) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.genLogicalPlan(CalcitePlanner.java:4508) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.apply(CalcitePlanner.java:1433) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.hadoop.hive.ql.parse.CalcitePlanner$CalcitePlannerAction.apply(CalcitePlanner.java:1380) ~[hive-exec-3.0.0.3.0.0.0-776.jar:3.0.0.3.0.0.0-776] at org.apache.calcite.tools.Frameworks$1.apply(Frameworks.java:118) ~[calcite-core-1.15.0.jar:1.15.0] at org.apache.calcite.prepare.CalcitePrepareImpl.perform(CalcitePrepareImpl.java:1052) ~[calcite-core-1.15.0.jar:1.15.0] at org.apache.calcite.tools.Frameworks.withPrepare(Frameworks.java:154) ~[calcite-core-1.15.0.jar:1.15.0] at org.apache.calcite.tools.Frameworks.withPlanner(Frameworks.java:111) ~[calcite-core-1.15.0.jar:1.15.0] at org.apache.hadoop.hive.ql.parse.CalcitePlanner.logicalPlan(CalcitePlanner.java:1185) {code} > Return type for udfs should be determined using Hive inference rules instead > of Calcite > --------------------------------------------------------------------------------------- > > Key: HIVE-18585 > URL: https://issues.apache.org/jira/browse/HIVE-18585 > Project: Hive > Issue Type: Bug > Components: Query Planning > Reporter: Ashutosh Chauhan > Assignee: Ashutosh Chauhan > Priority: Major > Attachments: HIVE-18585.patch > > > e.g., Calcite considers date and varchar incompatible types in case system, > while Hive doesn't. -- This message was sent by Atlassian JIRA (v7.6.3#76005)