[jira] [Comment Edited] (HIVE-17553) CBO wrongly type cast decimal literal to int

["Vineet Garg (JIRA)" <ji...@apache.org>]

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

Vineet Garg edited comment on HIVE-17553 at 10/5/17 11:24 PM:
--------------------------------------------------------------

This happens due to RexBuilder::makeExactLiteral (in calcite) creating Integer/BigInteger if scale happens to be zero. Hive probably need to create the type own its own and pass it to makeExactLiteral to preserve the type.


was (Author: vgarg):
This happens due to RexBuilder::makeExactLiteral creating Integer/BigInteger if scale happens to be zero. Hive probably need to create the type own its own and pass it to makeExactLiteral to preserve the type.

> CBO wrongly type cast decimal literal to int
> --------------------------------------------
>
>                 Key: HIVE-17553
>                 URL: https://issues.apache.org/jira/browse/HIVE-17553
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Planning
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>
> {code:sql}explain select 100.000BD from f{code}
> {noformat}
> STAGE PLANS:
>   Stage: Stage-0
>     Fetch Operator
>       limit: -1
>       Processor Tree:
>         TableScan
>           alias: f
>           Select Operator
>             expressions: 100 (type: int)
>             outputColumnNames: _col0
>             ListSink
> {noformat}
> Notice that the expression 100.000BD is of type int instead of decimal.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)