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)

Reply via email to