[
https://issues.apache.org/jira/browse/IMPALA-10153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17198142#comment-17198142
]
Shant Hovsepian edited comment on IMPALA-10153 at 9/18/20, 3:59 PM:
--------------------------------------------------------------------
A design doc for time travel might be a good idea. Typically the "AS OF" clause
is used for this, there had been a patch for Impala support with Kudu time
travel as an example https://gerrit.cloudera.org/c/13342/
[~gaborkaszab] for history I believe Iceberg has the syntax SELECT * from
table.history in other systems. This approach with a select statement
convenient in some more advanced use cases as it lets you put the metadata
history query into a subquery so you could do something like
{{AS OF (select snapshot_id from table.history where x=y)}}
was (Author: superdupershant):
A design doc for time travel might be a good idea. Typically the "AS OF" clause
is used for this, there had been a patch for Impala support with Kudu time
travel as an example https://issues.apache.org/jira/browse/KUDU-3177
[~gaborkaszab] for history I believe Iceberg has the syntax SELECT * from
table.history in other systems. This approach with a select statement
convenient in some more advanced use cases as it lets you put the metadata
history query into a subquery so you could do something like
{{AS OF (select snapshot_id from table.history where x=y)}}
> Support time travel for Iceberg tables
> --------------------------------------
>
> Key: IMPALA-10153
> URL: https://issues.apache.org/jira/browse/IMPALA-10153
> Project: IMPALA
> Issue Type: New Feature
> Reporter: Zoltán Borók-Nagy
> Assignee: Gabor Kaszab
> Priority: Major
> Labels: impala-iceberg
>
> Iceberg tables support snapshots/data versioning/time travel.
> It means we can query an older version of the table.
> Probably we'll need to extend Impala's SQL syntax to support such queries
> (Hive will also support such queries, so we should use the same syntax).
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
