[
https://issues.apache.org/jira/browse/HUDI-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Forward Xu updated HUDI-3221:
-----------------------------
Description:
Right now point-in-time queries are limited to what's retained by the cleaner.
If we fix this and expose via SQL, then it's a gap we close.
Dataframe read path support this option but not for SQL read path
[https://hudi.apache.org/docs/quick-start-guide/#time-travel-query]
SparkSQL Syntax
{code:java}
// code placeholder
SELECT * FROM A.B TIMESTAMP AS OF 1643119574;
SELECT * FROM A.B TIMESTAMP AS OF '2019-01-29 00:37:58';
SELECT * FROM A.B VERSION AS OF 'Snapshot123456789';{code}
was:
Right now point-in-time queries are limited to what's retained by the cleaner.
If we fix this and expose via SQL, then it's a gap we close.
Dataframe read path support this option but not for SQL read path
https://hudi.apache.org/docs/quick-start-guide/#time-travel-query
> Support querying a table as of a savepoint
> ------------------------------------------
>
> Key: HUDI-3221
> URL: https://issues.apache.org/jira/browse/HUDI-3221
> Project: Apache Hudi
> Issue Type: New Feature
> Components: hive, reader-core, spark, writer-core
> Reporter: Ethan Guo
> Assignee: Forward Xu
> Priority: Blocker
> Labels: user-support-issues
> Fix For: 0.11.0
>
>
> Right now point-in-time queries are limited to what's retained by the
> cleaner. If we fix this and expose via SQL, then it's a gap we close.
> Dataframe read path support this option but not for SQL read path
> [https://hudi.apache.org/docs/quick-start-guide/#time-travel-query]
> SparkSQL Syntax
> {code:java}
> // code placeholder
> SELECT * FROM A.B TIMESTAMP AS OF 1643119574;
> SELECT * FROM A.B TIMESTAMP AS OF '2019-01-29 00:37:58';
> SELECT * FROM A.B VERSION AS OF 'Snapshot123456789';{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
