You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Zoltán Borók-Nagy (Jira)" <ji...@apache.org> on 2025/03/22 16:13:00 UTC

[jira] [Created] (IMPALA-13888) LEFT ANTI JOIN is not working with Iceberg V2 tables on the right side

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)