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

[Naresh P R (Jira)]

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

Naresh P R updated HIVE-29509:
------------------------------
    Description: 
*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}

  was:
*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}


> 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
>            Priority: Major
>
> *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)