[jira] [Resolved] (HIVE-29509) Iceberg: Incorrect results if more than one snapshot (branch/tag/current) is involved in a query

["Ayush Saxena (Jira)" <ji...@apache.org>]

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

Ayush Saxena resolved HIVE-29509.
---------------------------------
    Fix Version/s: 4.3.0
       Resolution: Fixed

> Iceberg: Incorrect results if more than one snapshot (branch/tag/current) is involved in a query
> ------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-29509
>                 URL: https://issues.apache.org/jira/browse/HIVE-29509
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Naresh P R
>            Assignee: Ayush Saxena
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.3.0
>
>
> *Repro:*
> {code:java}
> CREATE EXTERNAL TABLE hive_branch_bug(foo BIGINT) STORED BY ICEBERG;
> ALTER TABLE hive_branch_bug CREATE BRANCH empty;
> INSERT INTO hive_branch_bug (foo) VALUES (1), (2), (3), (4);
> SELECT COUNT(*)
> FROM hive_branch_bug
> UNION ALL
> SELECT COUNT(*)
> FROM default.hive_branch_bug.branch_empty; {code}
> *Results:*
> {code:java}
> -- Expected result
> 4
> 0
> -- Actual wrong result
> 4
> 4{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)