[jira] [Commented] (DRILL-4552) During inference, treat decimal literals as Double when planner.enable_decimal_data_type is off

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

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

Sean Hsuan-Yi Chu commented on DRILL-4552:
------------------------------------------

This JIRA needs a calcite issue to be resolved: CALCITE-1219
1. Calcite PR: https://github.com/apache/calcite/pull/222
2. Drill: https://github.com/hsuanyi/incubator-drill/tree/DRILL-4552

Note that the DrillCalcite needs to incorporate the PR first. Otherwise, the branch of Drill above won't even compile.

> During inference, treat decimal literals as Double when planner.enable_decimal_data_type is off
> -----------------------------------------------------------------------------------------------
>
>                 Key: DRILL-4552
>                 URL: https://issues.apache.org/jira/browse/DRILL-4552
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Query Planning & Optimization
>            Reporter: Sean Hsuan-Yi Chu
>            Assignee: Sean Hsuan-Yi Chu
>
> In SQL standard, decimal literals (e.g., 1.2, 2.5, etc) are Decimal type. In Drill, when `planner.enable_decimal_data_type` is off, they are treated as Double. 
> However, the current inference mechanism is "not to do any inference if the operand is Decimal type". (To be more exact, treat them as ANY type and defer to the execution to make the decision.)
> The mechanism can be improved by treating decimal literals as Double when `planner.enable_decimal_data_type` is off.



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