You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "a bc (JIRA)" <ji...@apache.org> on 2013/10/17 07:30:42 UTC
[jira] [Created] (HIVE-5573) sql result messes up if char '0x0d '
in the database data file
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)