You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2018/01/30 21:08:00 UTC

[jira] [Commented] (HIVE-18585) Return type for udfs should be determined using Hive inference rules instead of Calcite

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