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

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Sean Hsuan-Yi Chu
• Created: 29/Mar/16 22:33
• Updated: 18/May/18 07:24
• Resolved: 18/May/18 07:24

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.

Issue Links

• relates to: DRILL-6094 Decimal data type enhancements