Time travel for Hive is only for Iceberg tables: https://issues.apache.org/jira/browse/HIVE-25344 <https://issues.apache.org/jira/browse/HIVE-25344> The syntax is: SELECT * FROM t FOR SYSTEM_TIME AS OF <timestamp>; SELECT * FROM t FOR SYSTEM_VERSION AS OF <version>;
Currently only Hive 4.0.0-alpha-1 release supports this feature. Thanks, Peteer > On 2022. May 20., at 8:54, second_co...@yahoo.com wrote: > > Hive server is configured to read delta lake folder from cloud storage. I > able to select * from tabletest using hive cli. But when I try > > describe history tabletest > > i get below error > > Error: Error while compiling statement: FAILED: SemanticException [Error > 10001]: Table not found history (state=42S02,code=10001) > > I also cannot execute > SELECT count(*) FROM tabletest VERSION AS OF 1 > > > Does anyone faced similar issue? I do not use Databrick. Does hive > cli/Beeline support above sql syntax? > > >
