Re: time travel using hive cli

2022-05-20 Thread Peter Vary
Delta did not contribute their code to the repo, so I think there are no plans to support this in the future in Apache Hive. > On 2022. May 20., at 9:42, second_co...@yahoo.com wrote: > > we don't use iceberg tables, only have Delta tables. So there is no plan to > support this in the future? A

Re: time travel using hive cli

2022-05-20 Thread Peter Vary
Time travel for Hive is only for Iceberg tables: https://issues.apache.org/jira/browse/HIVE-25344 The syntax is: SELECT * FROM t FOR SYSTEM_TIME AS OF ; SELECT * FROM t FOR SYSTEM_VERSION AS OF ; Currently only Hive 4.0.0-alpha-1 release support