hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1039) multi-insert doesn't work for local directories
Date Tue, 12 Jan 2010 18:07:54 GMT

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

Ning Zhang commented on HIVE-1039:
----------------------------------

Namit, do you mean something like this?

from (select * from src  union all select * from src) s
insert overwrite table src_multi1 select * where key < 10
insert overwrite table src_multi2 select * where key > 10 and key < 20;



> multi-insert doesn't work for local directories
> -----------------------------------------------
>
>                 Key: HIVE-1039
>                 URL: https://issues.apache.org/jira/browse/HIVE-1039
>             Project: Hadoop Hive
>          Issue Type: Bug
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>         Attachments: HIVE-1039.patch, HIVE-1039_2.patch
>
>
> As wd pointed out in hive-user, the following query only load data to the first local
directory. Multi-insert to tables works fine. 
> hive> from test
>     > INSERT OVERWRITE LOCAL DIRECTORY '/home/stefdong/tmp/0' select *
> where a = 1
>     > INSERT OVERWRITE LOCAL DIRECTORY '/home/stefdong/tmp/1' select *
> where a = 3;

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message