[jira] [Created] (HIVE-12749) Constant propagate returns string values in incorrect format

[Oleksiy Sayankin (JIRA)]

Oleksiy Sayankin created HIVE-12749:
---------------------------------------

             Summary: Constant propagate returns string values in incorrect 
format
                 Key: HIVE-12749
                 URL: https://issues.apache.org/jira/browse/HIVE-12749
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.2.0, 1.0.0
            Reporter: Oleksiy Sayankin
            Assignee: Oleksiy Sayankin
             Fix For: 2.0.0


h2. STEP 1. Create and upload test data

Execute in command line:

{noformat}
nano stest.data
{noformat}

Add to file:

{noformat}
000126,000777
000126,000778
000126,000779
000474,000888
000468,000889
000272,000880
{noformat}

{noformat}
hadoop fs -put stest.data /
{noformat}

{noformat}
hive> create table stest(x STRING, y STRING) ROW FORMAT DELIMITED FIELDS 
TERMINATED BY ',';
hive> LOAD DATA  INPATH '/stest.data' OVERWRITE INTO TABLE stest;
{noformat}

h2. STEP 2. Execute test query

{noformat}
hive> select x from stest where  x = 126; 
{noformat}

EXPECTED RESULT:
{noformat}
000126
000126
000126
{noformat}

ACTUAL RESULT:
{noformat}
126
126
126
{noformat}





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)