[HIVE-634] ctrl-A is the only output delimiter used, regardless of the Hive table structure

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 0.3.0
• Component/s: Serializers/Deserializers
• Assignee: Unassigned
• Reporter: Peter Skomoroch
• Created: 14/Jul/09 16:51
• Updated: 07/Jun/13 03:38
• Resolved: 07/Jun/13 03:38

Description

No matter what the table format, INSERT OVERWRITE LOCAL DIRECTORY will always use ctrl-A delimiters ('\001' ).

INSERT OVERWRITE LOCAL DIRECTORY '/mnt/daily_timelines' SELECT * FROM daily_timelines;

where daily_timelines is defined as tab delimited

CREATE TABLE daily_timelines (
page_id BIGINT,
dates STRING,
pageviews STRING,
total_pageviews BIGINT)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;

This page also indicates Hive uses a fixed delimiter, and should be updated:

http://wiki.apache.org/hadoop/Hive/LanguageManual/DML

Issue Links

• duplicates: HIVE-268 "Insert Overwrite Directory" to accept configurable table row format
• duplicates: HIVE-3682 when output hive table to file,users should could have a separator of their own choice
• relates to: HIVE-669 SELECT TRANSFORM / MAP / REDUCE to support optional ROW FORMAT