[HADOOP-4265] [Hive] error when user specifies the delimiter

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.19.0
• Assignee: Namit Jain
• Reporter: Namit Jain
• Created: 24/Sep/08 17:32
• Updated: 08/Jul/09 17:06
• Resolved: 21/Oct/08 18:45

Description

When the user specifies the delimiter (which is different from the default delimiter), the data is not processed correctly. Consider the test case:

CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012';
LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB;
SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB;
DROP TABLE INPUT4_CB

where kv1_cb.txt contains data seperated by Ctrl-B (\002) - the results are not as expected