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

["Boglarka Egyed (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-13888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Boglarka Egyed reassigned IMPALA-13888:
---------------------------------------

    Assignee: Daniel Becker

> 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org