hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "a bc (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-5573) sql result messes up if char '0x0d ' in the database data file
Date Thu, 17 Oct 2013 05:30:42 GMT
a bc created HIVE-5573:
--------------------------

             Summary: sql result messes up if char '0x0d ' in the database data file
                 Key: HIVE-5573
                 URL: https://issues.apache.org/jira/browse/HIVE-5573
             Project: Hive
          Issue Type: Bug
          Components: Database/Schema
    Affects Versions: 0.10.0
         Environment: CDH4.3
            Reporter: a bc
            Priority: Critical


with select statement, the returned result is not correct, totally messed up!

For example:
for table, we have:
hive> desc li2;
OK
sessionid       string
userid  string
groupid int
docid   string
channeltype     string
licensetype     string
issuitelicense  string
activationstatus        string
licensedproduct string

The real result when select this table :
hive> select * from tblfoo;
OK
7B179D5F-6D1A-4B00-89CC-5FE9F64A6D74    9EF52B8C-10D2-4C79-9460-6C295C9D5E7A   90       SUBSCRIPTION
   Trial   SUITE   NULL    NULL
        Trial   NULL    NULL    NULL    NULL    NULL    NULL    NULL

and the right result should be:
hive> select * from tblfoo;
OK
7B179D5F-6D1A-4B00-89CC-5FE9F64A6D74    9EF52B8C-10D2-4C79-9460-6C295C9D5E7A   90       SUBSCRIPTION
   Trial   SUITE   Trial   NOVALUE

If I remove the char '0x0d' in the database data file, then I can get the correct result.








--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message