[HIVE-5672] Insert with custom separator not supported for non-local directory

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0, 1.0.0
• Fix Version/s: 1.2.0
• Assignee: Nemon Lou
• Reporter: Romain Rigaux
• Created: 28/Oct/13 17:46
• Updated: 16/Feb/16 10:56
• Resolved: 30/Apr/15 21:10

Description

https://issues.apache.org/jira/browse/HIVE-3682 is great but non local directory don't seem to be supported:

insert overwrite directory '/tmp/test-02'
row format delimited
FIELDS TERMINATED BY ':'
select description FROM sample_07

Error while compiling statement: FAILED: ParseException line 2:0 cannot recognize input near 'row' 'format' 'delimited' in select clause

This works (with 'local'):

insert overwrite local directory '/tmp/test-02'
row format delimited
FIELDS TERMINATED BY ':'
select code, description FROM sample_07

Issue Links

• is duplicated by: HIVE-6833 when output hive table query to HDFS file,users should have a separator of their own choice
• is duplicated by: HIVE-6410 Allow output serializations separators to be set for HDFS path as well.
• is related to: LENS-518 Move Hive dependency to Apache Hive
• relates to: HIVE-13064 Serde properties are not working while expecting output in a directory
• relates to: HIVE-3682 when output hive table to file,users should could have a separator of their own choice