Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 17 Apr 2017 17:18:41 +0000 (UTC)
From: "Yongzhi Chen (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13063622.1492029842000.297722.1492449521709@Atlassian.JIRA>
In-Reply-To: <JIRA.13063622.1492029842000@Atlassian.JIRA>
References: <JIRA.13063622.1492029842000@Atlassian.JIRA> <JIRA.13063622.1492029842530@jira-lw-us.apache.org>
Subject: [jira] [Comment Edited] (HIVE-16427) Fix multi-insert query and
 write qtests
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 17 Apr 2017 17:18:46 -0000


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

Yongzhi Chen edited comment on HIVE-16427 at 4/17/17 5:18 PM:
--------------------------------------------------------------

[~ashutoshc], is it true that from TS to LIM0 (or the null Filter), if there are any branch between the two operations, the need to convertMetadataOnly will be false ?
For example:
TS -OP1-OP2-OP3-LIM0 will need to convertMetadataOnly,

But following will not: 
{noformat}
TS-OP1-OP2-OP3-LIM0
        |
      OP4
{noformat}


was (Author: ychena):
[~ashutoshc], is it true that from TS to LIM0 (or the null Filter), if there are any branch between the two operations, the need to convertMetadataOnly will be false ?
For example:
TS -OP1-OP2-OP3-LIM0 will need to convertMetadataOnly,

But following will not: 
TS-OP1-OP2-OP3-LIM0
        |
      OP4

> Fix multi-insert query and write qtests
> ---------------------------------------
>
>                 Key: HIVE-16427
>                 URL: https://issues.apache.org/jira/browse/HIVE-16427
>             Project: Hive
>          Issue Type: Bug
>          Components: Logical Optimizer
>            Reporter: Thomas Poepping
>            Assignee: Yongzhi Chen
>         Attachments: HIVE-16427.1.patch
>
>
> On HIVE-16415, it was found that the bug reported to be fixed in HIVE-14519 was not actually fixed.
> This task is to find the problem, fix it, and add qtests to verify no future regression.
> Specifically, the following query does not produce correct answers: 
> {code}
> From (select * from src) a
> insert overwrite directory '/tmp/emp/dir1/'
> select key, value
> insert overwrite directory '/tmp/emp/dir2/'
> select 'header'
> limit 0
> insert overwrite directory '/tmp/emp/dir3/'
> select key, value 
> where key = 100;
> {code}
> This gives incorrect result in master. All dirs end up with 0 rows instead of just dir2.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)