[ 
https://issues.apache.org/jira/browse/SPARK-34978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17319375#comment-17319375
 ] 

Yann Byron commented on SPARK-34978:
------------------------------------

[~hyukjin.kwon] 

Do you mean we should implement time-travel in the side of Delta, instead of 
Spark ?

 

If yes, I think time-travel is a relatively common function for datasource 
which has the ability to manage historical snapshots, so than I raise this 
issue.

These is some discuss about it: [https://github.com/delta-io/delta/issues/128]

 

> Support time-travel SQL syntax
> ------------------------------
>
>                 Key: SPARK-34978
>                 URL: https://issues.apache.org/jira/browse/SPARK-34978
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 3.1.1
>            Reporter: Yann Byron
>            Priority: Major
>
> Some DataSource have the ability to query the older snapshot, like Delta.
> The syntax may be like `TIMESTAMP AS OF '
> 2018-10-18 22:15:12' ` to query the snapshot closest to this time point, or 
> `VERSION AS OF 12` to query the 12th snapshot.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to