[
https://issues.apache.org/jira/browse/HIVE-16842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16042289#comment-16042289
]
anishek commented on HIVE-16842:
--------------------------------
cc [~sershe]
> 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
> Fix For: 3.0.0
>
>
> {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
(v6.3.15#6346)
