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

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

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)