[
https://issues.apache.org/jira/browse/DRILL-4552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Hsuan-Yi Chu updated DRILL-4552:
-------------------------------------
Description:
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.
was:
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.
In the context of type inference, the current behavior 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.) However,
> 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)
