[ https://issues.apache.org/jira/browse/HIVE-5672?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13900031#comment-13900031 ]
Viji commented on HIVE-5672: ---------------------------- Such a workaround as noted in that comment is painful as explained by Amareshwari at https://issues.apache.org/jira/browse/HIVE-6410 (schema knowledge requirement). We can mark either one as dupe but we do need this feature. > Insert with custom separator not supported for non-local directory > ------------------------------------------------------------------ > > Key: HIVE-5672 > URL: https://issues.apache.org/jira/browse/HIVE-5672 > Project: Hive > Issue Type: Bug > Affects Versions: 0.12.0 > Reporter: Romain Rigaux > Assignee: Xuefu Zhang > > https://issues.apache.org/jira/browse/HIVE-3682 is great but non local > directory don't seem to be supported: > {code} > insert overwrite directory '/tmp/test-02' > row format delimited > FIELDS TERMINATED BY ':' > select description FROM sample_07 > {code} > {code} > Error while compiling statement: FAILED: ParseException line 2:0 cannot > recognize input near 'row' 'format' 'delimited' in select clause > {code} > This works (with 'local'): > {code} > insert overwrite local directory '/tmp/test-02' > row format delimited > FIELDS TERMINATED BY ':' > select code, description FROM sample_07 > {code} -- This message was sent by Atlassian JIRA (v6.1.5#6160)