ABHISHEK KUMAR GUPTA created HIVE-24361:
-------------------------------------------
Summary: Insert overwrite with empty data is different in normal
table then transactional table
Key: HIVE-24361
URL: https://issues.apache.org/jira/browse/HIVE-24361
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 3.1.0
Reporter: ABHISHEK KUMAR GUPTA
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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
