You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Gabor Kaszab (Jira)" <ji...@apache.org> on 2020/10/28 14:12:00 UTC
[jira] [Assigned] (IMPALA-10288) Functionality to display table
history for Iceberg tables
[ https://issues.apache.org/jira/browse/IMPALA-10288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gabor Kaszab reassigned IMPALA-10288:
-------------------------------------
Assignee: Gabor Kaszab
> Functionality to display table history for Iceberg tables
> ---------------------------------------------------------
>
> Key: IMPALA-10288
> URL: https://issues.apache.org/jira/browse/IMPALA-10288
> Project: IMPALA
> Issue Type: Sub-task
> Components: Frontend
> Reporter: Gabor Kaszab
> Assignee: Gabor Kaszab
> Priority: Major
>
> For time travel it would be useful to display the table history (previous snapshot, creation times etc.) so that the user can pick which snapshot to use.
> Spark already has this functionality:
> https://iceberg.apache.org/spark/#time-travel
> {code:java}
> SELECT * FROM prod.db.table.history
> {code}
> {code:java}
> +-------------------------+---------------------+---------------------+---------------------+
> | made_current_at | snapshot_id | parent_id | is_current_ancestor |
> +-------------------------+---------------------+---------------------+---------------------+
> | 2019-02-08 03:29:51.215 | 5781947118336215154 | NULL | true |
> | 2019-02-08 03:47:55.948 | 5179299526185056830 | 5781947118336215154 | true |
> | 2019-02-09 16:24:30.13 | 296410040247533544 | 5179299526185056830 | false |
> | 2019-02-09 16:32:47.336 | 2999875608062437330 | 5179299526185056830 | true |
> | 2019-02-09 19:42:03.919 | 8924558786060583479 | 2999875608062437330 | true |
> | 2019-02-09 19:49:16.343 | 6536733823181975045 | 8924558786060583479 | true |
> +-------------------------+---------------------+---------------------+---------------------+
> {code}
> We can have the same output columns for the Impala implementation, however, the actual syntax to run the query is not decided yet.
> There are various solutions on the field:
> 1) SELECT * from tablename.history; (Spark)
> 2) DESCRIBE HISTORY tablename; (Delta)
> 3) select * from 'table.history'; (Presto)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org