[HIVE-268] "Insert Overwrite Directory" to accept configurable table row format

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Query Processor
• Assignee: Paul Yang
• Reporter: Zheng Shao
• Created: 03/Feb/09 19:43
• Updated: 07/Jun/13 03:37
• Resolved: 07/Jun/13 03:37

Description

There is no way for the users to control the file format when they are outputting the result into a directory.

We should allow:

INSERT OVERWRITE DIRECTORY "/user/zshao/result"
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '9'
SELECT tablea.* from tablea;

Issue Links

• duplicates: HIVE-3682 when output hive table to file,users should could have a separator of their own choice
• is duplicated by: HIVE-634 ctrl-A is the only output delimiter used, regardless of the Hive table structure