[HIVE-24361] Insert overwrite with empty data is different in normal table then transactional table

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: Hive
• Assignee: Unassigned
• Reporter: ABHISHEK KUMAR GUPTA
• Created: 09/Nov/20 07:26
• Updated: 09/Nov/20 11:08

Description

Steps:
Use Case 1:
create table test3(id int);
insert into table test3 values(20);
create table test4(id int);
insert overwrite table test3 select * from test4;
select * from test 3;
Result: 0 rows

Use Case 2:
For transnational Table:
create table test1(id int) stored as orc tblproperties('transactional'='true');
insert into test1 values(20);
create table test2(id int) stored as orc tblproperties('transactional'='true');
insert overwrite table test1 select * from test2;
select * from test 1;
Result: 1 rows

Expectation: Use Case 1 should behave as Use Case 2.