Ashutosh Chauhan created HIVE-8555:
--------------------------------------
Summary: Too many casts results in loss of original string
representation for constant
Key: HIVE-8555
URL: https://issues.apache.org/jira/browse/HIVE-8555
Project: Hive
Issue Type: Bug
Components: Logical Optimizer
Affects Versions: 0.14.0
Reporter: Ashutosh Chauhan
Assignee: Ashutosh Chauhan
{code}
SELECT key, value FROM src WHERE key= cast(86 as double);
86.0 val_86
{code}
With constant propagate off we get different and correct result.
{code}
set hive.optimize.constant.propagation=false;
SELECT key, value FROM src WHERE key= cast(86 as double);
86 val_86
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
