You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2009/02/03 20:43:59 UTC

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

"Insert Overwrite Directory" to accept configurable table row format
--------------------------------------------------------------------

                 Key: HIVE-268
                 URL: https://issues.apache.org/jira/browse/HIVE-268
             Project: Hadoop Hive
          Issue Type: New Feature
          Components: Query Processor
            Reporter: Zheng Shao


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.
-
You can reply to this email to add a comment to the issue online.

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

Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12910656#action_12910656 ] 

Edward Capriolo commented on HIVE-268:
--------------------------------------

Still not exactly what you want but with CTAS you can essentially get a folder in /user/hive/warehouse/<tableIWant> with the format you want.

> "Insert Overwrite Directory" to accept configurable table row format
> --------------------------------------------------------------------
>
>                 Key: HIVE-268
>                 URL: https://issues.apache.org/jira/browse/HIVE-268
>             Project: Hadoop 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.
-
You can reply to this email to add a comment to the issue online.

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

Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Yang reassigned HIVE-268:
------------------------------

    Assignee: Paul Yang

> "Insert Overwrite Directory" to accept configurable table row format
> --------------------------------------------------------------------
>
>                 Key: HIVE-268
>                 URL: https://issues.apache.org/jira/browse/HIVE-268
>             Project: Hadoop 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.
-
You can reply to this email to add a comment to the issue online.

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

Posted by "Arun (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12910530#action_12910530 ] 

Arun commented on HIVE-268:
---------------------------

Hi Team,

 Have you find any solution for this issue or is there any other way to achieve this above ?

Thanks,
Jak

> "Insert Overwrite Directory" to accept configurable table row format
> --------------------------------------------------------------------
>
>                 Key: HIVE-268
>                 URL: https://issues.apache.org/jira/browse/HIVE-268
>             Project: Hadoop 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.
-
You can reply to this email to add a comment to the issue online.