You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ádám Szita (Jira)" <ji...@apache.org> on 2022/11/15 10:02:00 UTC
[jira] [Updated] (HIVE-26187) Set operations and time travel is not working
[ https://issues.apache.org/jira/browse/HIVE-26187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ádám Szita updated HIVE-26187:
------------------------------
Component/s: Iceberg integration
> 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
> Components: Iceberg integration
> 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.10#820010)