hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oleksiy Sayankin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12749) Constant propagate returns string values in incorrect format
Date Fri, 25 Dec 2015 13:04:49 GMT
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)

Mime
View raw message