[
https://issues.apache.org/jira/browse/HIVE-16427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergio Peña updated HIVE-16427:
-------------------------------
Description:
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.
was:
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}
> 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
>
> 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)
