You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Romain Rigaux (JIRA)" <ji...@apache.org> on 2013/10/28 18:46:41 UTC

[jira] [Created] (HIVE-5672) Insert with custom separator not supported for local directory

Romain Rigaux created HIVE-5672:
-----------------------------------

             Summary: Insert with custom separator not supported for 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


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#6144)