You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2009/03/08 17:23:56 UTC

[jira] Commented: (HIVE-308) UNION ALL should create different destination directories for different operands

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

Namit Jain commented on HIVE-308:
---------------------------------

Zheng, there are a lot of problems with union, and I am in the process of fixing them in:

https://issues.apache.org/jira/browse/HIVE-318

Some corner cases are not working, and I should be done hopefully in a day or 2.
Can you hold on to this patch - let us look at these 2 patches together and then decide

> UNION ALL should create different destination directories for different operands
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-308
>                 URL: https://issues.apache.org/jira/browse/HIVE-308
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.3.0
>            Reporter: Zheng Shao
>            Priority: Blocker
>         Attachments: HIVE-308.1.patch
>
>
> The following query hangs:
> {code} 
> select * from (select 1 from zshao_lazy union all select 2 from zshao_lazy) a;
> {code} 
> The following query produce wrong results: (one map-reduce job overwrite/cannot overwrite the result of the other)
> {code} 
> select * from (select 1 as id from zshao_lazy cluster by id union all select 2 as id from zshao_meta) a;
> {code} 
> The reason of both is that the destination directory of the file sink operator conflicts with each other.

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