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? Any issue ticket in github tracking this? > > On Friday, May 20, 2022, 03:28:04 PM GMT+8, Peter Vary <pv...@cloudera.com> > wrote: > > > 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 >> <mailto: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? >> >> >> >
