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

[jira] [Created] (IMPALA-11740) Incorrect results for partitioned Iceberg V2 tables when runtime filters are applied

Zoltán Borók-Nagy created IMPALA-11740:
------------------------------------------

             Summary: Incorrect results for partitioned Iceberg V2 tables when runtime filters are applied
                 Key: IMPALA-11740
                 URL: https://issues.apache.org/jira/browse/IMPALA-11740
             Project: IMPALA
          Issue Type: Bug
            Reporter: Zoltán Borók-Nagy


If an Iceberg V2 table is partitioned, and contains delete files, then in a query that involves runtime filters on the partition columns return empty result set.

{noformat}
select count(*) from store_sales, date_dim where d_date_sk = ss_sold_date_sk and d_moy=2 and d_year=1998;
{noformat}

In the above query store_sales is partitioned  by ss_sold_date_sk which will be filtered by runtime filters created by the JOIN. If store_sales has delete files then the above query returns empty result set.



--
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