[ 
https://issues.apache.org/jira/browse/IMPALA-14154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17979897#comment-17979897
 ] 

Daniel Becker commented on IMPALA-14154:
----------------------------------------

I could reproduce the error just after IMPALA-11484, so we've always had this 
bug since we started supporting position delete files.

> IllegalStateException with Iceberg table with DELETE
> ----------------------------------------------------
>
>                 Key: IMPALA-14154
>                 URL: https://issues.apache.org/jira/browse/IMPALA-14154
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Daniel Becker
>            Assignee: Daniel Becker
>            Priority: Major
>              Labels: impala-iceberg
>
> The following SQL returns an IllegalStateException:
> {code:java}
> DROP DATABASE IF EXISTS db CASCADE;
> CREATE DATABASE db;
> CREATE TABLE db.tbl1 (
>     uuid1 BIGINT
> );
> CREATE TABLE db.tbl2 (
>     uuid2 BIGINT
> ) STORED AS ICEBERG TBLPROPERTIES ('format-version'='2');
> INSERT INTO db.tbl2 VALUES
> (1005),
> (1006);
> DELETE FROM db.tbl2 WHERE uuid2 = 1005;
> SELECT uuid2
> FROM db.tbl2
> WHERE uuid2 NOT IN
>     (SELECT uuid1
>      FROM db.tbl1);
> {code}



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org

Reply via email to