[
https://issues.apache.org/jira/browse/IMPALA-13888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17985896#comment-17985896
]
Csaba Ringhofer commented on IMPALA-13888:
------------------------------------------
saw a similar issue with deleted tables and collections:
create table tdelcoll (i int, a array<int>) stored as iceberg;
alter table tdelcoll set tblpropertes('format-version'='2');
from Hive: insert into tdelcoll values (1, array(2,3));
from Hive: insert into tdelcoll values (2, array(3,4)), (3, array(4,5));
delete from tdelcoll where i=2;
select item from tdelcoll.a;
result: AnalysisException: Could not resolve column/field reference:
'tdelcoll.a.input__file__name'
> LEFT ANTI JOIN is not working with Iceberg V2 tables on the right side
> ----------------------------------------------------------------------
>
> Key: IMPALA-13888
> URL: https://issues.apache.org/jira/browse/IMPALA-13888
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Reporter: Zoltán Borók-Nagy
> Assignee: Daniel Becker
> Priority: Major
> Labels: impala-iceberg
>
> Repro:
> {noformat}
> select *
> from alltypes a LEFT ANTI JOIN iceberg_v2_positional_update_all_rows b
> ON a.id = b.i;
> AnalysisException: Illegal column/field reference 'b.input__file__name' of
> semi-/anti-joined table 'b'{noformat}
> The followings work as expected
> {noformat}
> select *
> from iceberg_v2_positional_update_all_rows a LEFT ANTI JOIN
> iceberg_partitioned b
> ON a.i = b.id;
> select *
> from iceberg_partitioned a LEFT ANTI JOIN iceberg_partitioned b
> ON a.id = b.id;{noformat}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
