[HIVE-8555] Too many casts results in loss of original string representation for constant

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Component/s: Logical Optimizer
• Assignee: Ashutosh Chauhan
• Reporter: Ashutosh Chauhan
• Created: 22/Oct/14 00:42
• Updated: 13/Nov/14 19:40
• Resolved: 22/Oct/14 22:22

Description

SELECT key, value FROM src WHERE key = cast(86 as double);
86.0  val_86

With constant propagate off we get different and correct result.

set hive.optimize.constant.propagation=false;
SELECT key, value FROM src WHERE key =  cast(86 as double);
86  val_86