[ https://issues.apache.org/jira/browse/HUDI-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Raymond Xu updated HUDI-3221: ----------------------------- Status: In Progress (was: Open) > 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)