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-16427) Fix multi-insert query and write qtests
Date Mon, 17 Apr 2017 16:27:42 GMT

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

Ashutosh Chauhan commented on HIVE-16427:
-----------------------------------------

Logic to determine if its a multi-insert query is not correct. It assumes its TS-SEL-LIM pipeline
which is not necessarily true, you may have arbitrary number of operators between LIM and
TS. You need to traverse the tree. Similar improvement needs to be made for where false case
as well.

> 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)

Mime
View raw message