[
https://issues.apache.org/jira/browse/HIVE-16842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792408#comment-16792408
]
Abhishek Somani commented on HIVE-16842:
----------------------------------------
[~vgarg] [~ashutoshc] are we planning to fix this?
> insert overwrite with select does not remove data when the select query
> returns empty resultset
> -----------------------------------------------------------------------------------------------
>
> Key: HIVE-16842
> URL: https://issues.apache.org/jira/browse/HIVE-16842
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 3.0.0
> Reporter: anishek
> Priority: Major
>
> {code}create table address (city string);
> insert into address values ('b');
> create table empty_insert (city string);
> insert into empty_insert values ('a');
> insert overwrite table empty_insert select city from address where city='g';
> {code}
> empty_insert still contains 'a'; # should be nothing
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
