Zoltán Borók-Nagy created IMPALA-13888:
------------------------------------------
Summary: 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
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)
