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