[ 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