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

Reply via email to