drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Hsuan-Yi Chu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-4552) During inference, treat decimal literals as Double when planner.enable_decimal_data_type is off
Date Thu, 28 Apr 2016 00:22:12 GMT

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

Mime
View raw message