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

[Naresh P R (Jira)]

Naresh P R created HIVE-29509:
---------------------------------

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


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