[
https://issues.apache.org/jira/browse/HIVE-24361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17228469#comment-17228469
]
Ivan Suller commented on HIVE-24361:
------------------------------------
[~abhishek.akg] but the whole point of overwriting is to replace the data
currently in the table.
Btw, we had tickets similar to this one: HIVE-18702, HIVE-21714, HIVE-21784
where the expectation was to overwrite the data with the empty new one. Based
on that the correct behavior is the one with non-transaction table (Use Case 1).
> 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
> Priority: Minor
>
> 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)
