[HIVE-16842] insert overwrite with select does not remove data when the select query returns empty resultset

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: HiveServer2
• Assignee: Unassigned
• Reporter: Anishek Agarwal
• Created: 07/Jun/17 09:19
• Updated: 14/Mar/19 06:55

Description

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';

empty_insert still contains 'a'; # should be nothing