[jira] [Updated] (HUDI-3221) Support querying a table as of a savepoint

["Rajesh Mahindra (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HUDI-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajesh Mahindra updated HUDI-3221:
----------------------------------
    Sprint: Hudi-Sprint-Jan-24, Hudi-Sprint-Jan-31  (was: Hudi-Sprint-Jan-24)

> 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: pull-request-available, 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)