hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14519) Multi insert query bug
Date Sat, 13 Aug 2016 17:45:20 GMT

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

Ashutosh Chauhan commented on HIVE-14519:
-----------------------------------------

+1

> Multi insert query bug
> ----------------------
>
>                 Key: HIVE-14519
>                 URL: https://issues.apache.org/jira/browse/HIVE-14519
>             Project: Hive
>          Issue Type: Bug
>          Components: Logical Optimizer
>            Reporter: Yongzhi Chen
>            Assignee: Yongzhi Chen
>         Attachments: HIVE-14519.1.patch
>
>
> When running multi-insert queries, when one of the query is not returning results, the
other query is not returning the right result.
> For example:
> After following query, there is no value in /tmp/emp/dir3/000000_0
> {noformat}
> From (select * from src) a
> insert overwrite directory '/tmp/emp/dir1/'
> select key, value
> insert overwrite directory '/tmp/emp/dir2/'
> select 'header'
> where 1=2
> insert overwrite directory '/tmp/emp/dir3/'
> select key, value 
> where key = 100;
> {noformat}
> where clause in the second insert should not affect the third insert. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message