[ 
https://issues.apache.org/jira/browse/HIVE-28790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Marta Kuczora updated HIVE-28790:
---------------------------------
    Description: 
Steps to reproduce:

{code:java}
    set mapreduce.job.reduces=7;
    create external table ext(a int) stored as textfile;
    insert into table ext values(1),(2),(3),(4),(5),(6),(7), (8), (9), (12);
    create table full_acid(a int) stored as orc 
tblproperties("transactional"="true");

    insert into table full_acid select * from ext where a != 3 and a <=7 group 
by a;
    insert into table full_acid select * from ext where a>7 group by a;

    set mapreduce.job.reduces=1;
    delete from full_acid where a in (2, 12);
{code}

The delete will fail with the following exception:
Caused by: java.lang.ArrayIndexOutOfBoundsException: 6
        at 
org.apache.hadoop.hive.ql.exec.FileSinkOperator$FSPaths.closeWriters(FileSinkOperator.java:258)

> ACID deletes are failing with ArrayIndexOutOfBoundsException when direct 
> insert is enabled 
> -------------------------------------------------------------------------------------------
>
>                 Key: HIVE-28790
>                 URL: https://issues.apache.org/jira/browse/HIVE-28790
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 4.0.0
>            Reporter: Marta Kuczora
>            Priority: Major
>
> Steps to reproduce:
> {code:java}
>     set mapreduce.job.reduces=7;
>     create external table ext(a int) stored as textfile;
>     insert into table ext values(1),(2),(3),(4),(5),(6),(7), (8), (9), (12);
>     create table full_acid(a int) stored as orc 
> tblproperties("transactional"="true");
>     insert into table full_acid select * from ext where a != 3 and a <=7 
> group by a;
>     insert into table full_acid select * from ext where a>7 group by a;
>     set mapreduce.job.reduces=1;
>     delete from full_acid where a in (2, 12);
> {code}
> The delete will fail with the following exception:
> Caused by: java.lang.ArrayIndexOutOfBoundsException: 6
>       at 
> org.apache.hadoop.hive.ql.exec.FileSinkOperator$FSPaths.closeWriters(FileSinkOperator.java:258)



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

Reply via email to