[HIVE-17553] CBO wrongly type cast decimal literal to int

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Query Planning
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 19/Sep/17 00:20
• Updated: 22/May/18 23:13
• Resolved: 09/Oct/17 20:25

Description

explain select 100.000BD from f

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: f
          Select Operator
            expressions: 100 (type: int)
            outputColumnNames: _col0
            ListSink

Notice that the expression 100.000BD is of type int instead of decimal.

Issue Links

• is related to: HIVE-17535 Select 1 EXCEPT Select 1 fails with NPE