[jira] [Commented] (HIVE-26187) Set operations and time travel is not working

["László Pintér (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-26187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17531629#comment-17531629 ] 

László Pintér commented on HIVE-26187:
--------------------------------------

[~boroknagyz] Although the syntax of hive allows minus operation, this feature was not completed entirely. It was introduced through HIVE-12765. I will open a follow-up Jira to complete it. 

> Set operations and time travel is not working
> ---------------------------------------------
>
>                 Key: HIVE-26187
>                 URL: https://issues.apache.org/jira/browse/HIVE-26187
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Zoltán Borók-Nagy
>            Assignee: László Pintér
>            Priority: Major
>              Labels: iceberg
>
> Set operations doesn't work well with time travel queries.
> Repro:
> {noformat}
> select * from  t FOR SYSTEM_VERSION AS OF <snapshot_id_1>
> MINUS
> select * from t FOR SYSTEM_VERSION AS OF <snapshot_id_2>;
> {noformat}
> Returns 0 results because both selects use the same snapshot id, instead of snapshot_id_1 and snapshot_id_2.
> Probably there're issues with other queries as well, when the same table is used multiple times with different snapshot ids.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)