Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-10153 Support time travel for Iceberg tables
  3. IMPALA-10840

Add support for "FOR SYSTEM_TIME AS OF" and "FOR SYSTEM_VERSION AS OF" for Iceberg tables

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • ghx-label-14

    Description

      SQL11 introduced a couple of temporal features:
      https://cs.ulb.ac.be/public/_media/teaching/infoh415/tempfeaturessql2011.pdf

      One of them is FOR SYSTEM_TIME AS OF which can be part of the table reference:
      https://jakewheat.github.io/sql-overview/sql-2011-foundation-grammar.html#query-system-time-period-specification

      With this extension the users are able to query the table at a given time point.

      HIVE-25344 also added support for this. It also adds another, non-standard clause: FOR SYSTEM_VERSION AS OF.

      In Impala we should add both to support time travel for Iceberg tables.

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            boroknagyz Zoltán Borók-Nagy
            boroknagyz Zoltán Borók-Nagy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment