Sourabh Badhya created HIVE-28167:
-------------------------------------
Summary: Iceberg: Full table deletion fails when using
Copy-on-write
Key: HIVE-28167
URL: https://issues.apache.org/jira/browse/HIVE-28167
Project: Hive
Issue Type: Bug
Reporter: Sourabh Badhya
Assignee: Sourabh Badhya
A simple repro -
{code:java}
create table ice01 (id int, key int) stored by iceberg stored as orc
tblproperties ('format-version'='2', 'write.delete.mode'='copy-on-write');
insert into ice01 values (1,1),(2,1),(3,1),(4,1);
insert into ice01 values (1,2),(2,2),(3,2),(4,2);
insert into ice01 values (1,3),(2,3),(3,3),(4,3);
insert into ice01 values (1,4),(2,4),(3,4),(4,4);
insert into ice01 values (1,5),(2,5),(3,5),(4,5);
explain analyze delete from ice01;
delete from ice01;
select count(*) from ice01;
select * from ice01;
describe formatted ice01; {code}
The solution is to convert full table deletion to a truncate operation on the
table.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
