Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1912

Support "FOR SYSTEM_TIME AS OF" in regular queries

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.19.0
    • Component/s: None

      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

        Attachments

          Issue Links

          is depended upon by

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-1917 Support column reference in "FOR SYSTEM_TIME AS OF"

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4526 SqlSnapshot unparse lost the AS keyword when the table has alias

          • Blocker - Blocks development and/or testing work, production could not run
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3620 Remove implicit lateral operator for temporal table join

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #759

          Web Link PR759

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jark Jark Wu
              • Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m