Denys Kuzmenko created HIVE-28366:
-------------------------------------

             Summary: Iceberg: Concurrent Insert and IOW produce incorrect 
result 
                 Key: HIVE-28366
                 URL: https://issues.apache.org/jira/browse/HIVE-28366
             Project: Hive
          Issue Type: Bug
          Components: Iceberg integration
    Affects Versions: 4.0.0
            Reporter: Denys Kuzmenko


1. create a table and insert some data:
{code}
create table ice_t (i int, p int) partitioned by spec (truncate(10, i)) stored 
by iceberg;

insert into ice_t values (1, 1), (2, 2);
insert into ice_t values (10, 10), (20, 20);
insert into ice_t values (40, 40), (30, 30);
{code}
Then concurrently execute the following jobs:
Job 1:
{code}
insert into ice_void select i*100, p*100 from ice_void;
{code}
Job 2:
{code}
insert overwrite ice_void select i+1, p+1 from ice_void;
{code}
If Job 1 finishes first, Job 2 still succeeds for me, and after that the table 
content will be the following:
{code}
2      2
3      3
11     11
21     21
31     31
41     41
100    100
200    200
1000   1000
2000   2000
3000   3000
4000   4000
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to