[SPARK-34978] Support time-travel SQL syntax

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.1.1
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yann Byron
• Created: 07/Apr/21 06:40
• Updated: 12/Dec/22 18:10
• Resolved: 01/Jul/22 05:39

Description

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.

Issue Links

• duplicates: SPARK-37219 support AS OF syntax