[
https://issues.apache.org/jira/browse/HIVE-16415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15964940#comment-15964940
]
Ashutosh Chauhan commented on HIVE-16415:
-----------------------------------------
I did little bit more testing on this, taking an example query from HIVE-14519
and modified it as following:
{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. I think fix in HIVE-14519 is incomplete.
> Add blobstore tests for insertion of zero rows
> ----------------------------------------------
>
> Key: HIVE-16415
> URL: https://issues.apache.org/jira/browse/HIVE-16415
> Project: Hive
> Issue Type: Test
> Components: Tests
> Affects Versions: 2.1.1
> Reporter: Thomas Poepping
> Assignee: Thomas Poepping
> Attachments: HIVE-16415.patch
>
>
> This patch introduces two regression tests into the hive-blobstore qtest
> module: zero_rows_hdfs.q and zero_rows_blobstore.q. These test doing INSERT
> commands with a WHERE clause where the condition of the WHERE clause causes
> zero rows to be considered.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
