Daniel Becker created IMPALA-14154:
--------------------------------------

             Summary: 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


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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to