[CALCITE-1912] Support "FOR SYSTEM_TIME AS OF" in regular queries

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jark Wu
• Created: 01/Aug/17 06:27
• Updated: 09/Mar/21 19:06
• Resolved: 08/Mar/19 18:21

Description

As discussed in mailling list[1], we hope to support "FOR SYSTEM_TIME AS OF" in Calcite to retrieve table contents as of a given point in time.

[1] https://lists.apache.org/thread.html/f877f356a8365bf74ea7d8e4a171224104d653cf73861afb2901a58f@%3Cdev.calcite.apache.org%3E

Issue Links

• is depended upon by: CALCITE-1917 Support column reference in "FOR SYSTEM_TIME AS OF"
• relates to: CALCITE-4526 SqlSnapshot unparse lost the AS keyword when the table has alias
• relates to: CALCITE-3620 Remove implicit lateral operator for temporal table join
• links to: GitHub Pull Request #759
• links to: PR759