[jira] [Commented] (HIVE-268) "Insert Overwrite Directory" to accept configurable table row format

["Alex Newman (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13086633#comment-13086633 ] 

Alex Newman commented on HIVE-268:
----------------------------------

I think the issue here is he wants to write to a local file and choose the delim. Currently you can only do one or the other. 

> "Insert Overwrite Directory" to accept configurable table row format
> --------------------------------------------------------------------
>
>                 Key: HIVE-268
>                 URL: https://issues.apache.org/jira/browse/HIVE-268
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Zheng Shao
>            Assignee: Paul Yang
>
> There is no way for the users to control the file format when they are outputting the result into a directory.
> We should allow:
> {code}
> INSERT OVERWRITE DIRECTORY "/user/zshao/result"
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '9'
> SELECT tablea.* from tablea;
> {code}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira