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/27 10:51:00 UTC
[jira] [Created] (IMPALA-10288) Functionality to display table
history for Iceberg tables
Gabor Kaszab created IMPALA-10288:
-------------------------------------
Summary: 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
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