Zoltán Borók-Nagy created HIVE-26187:
----------------------------------------
Summary: 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
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)
