[
https://issues.apache.org/jira/browse/IMPALA-11116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17512420#comment-17512420
]
ASF subversion and git services commented on IMPALA-11116:
----------------------------------------------------------
Commit 72f074539c4bb2fe663d748f97cd62df88337f27 in impala's branch
refs/heads/master from Tamas Mate
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=72f0745 ]
IMPALA-11116: Make DESCRIBE HISTORY parameterized
The numer of snapshots can grow large, because every INSERT can create a
new one. This patch adds inclusive predicates to narrow down the
resultset of the DESCRIBE HISTORY statement, these are:
- DESCRIBE HISTORY <table> FROM <ts>
- DESCRIBE HISTORY <table> BETWEEN <ts> AND <ts>
The timestamps can be date time values and intervals as well, such as:
- '2022-02-04 13:31:09.819'
- 'now() - interval 2 days'
Testing:
- Added e2e tests that verifies the result.
- Added unit tests that checks the analysis.
Change-Id: Ifead0d33f22069005bfd623460f4af1ff197cc0e
Reviewed-on: http://gerrit.cloudera.org:8080/18284
Tested-by: Impala Public Jenkins <[email protected]>
Reviewed-by: Zoltan Borok-Nagy <[email protected]>
> DESCRIBE HISTORY should be parameterized
> ----------------------------------------
>
> Key: IMPALA-11116
> URL: https://issues.apache.org/jira/browse/IMPALA-11116
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Reporter: Zoltán Borók-Nagy
> Assignee: Tamas Mate
> Priority: Major
> Labels: impala-iceberg
>
> Currently DESCRIBE HISTORY lists the whole history of the table.
> This could be a very long list. It would be good if the statement had
> filtering capabilities.
> E.g.:
> {noformat}
> DESCRIBE HISTORY <table> BETWEEN <ts1> AND <ts2>;
> DESCRIBE HISTORY <table> FROM <ts>;
> {noformat}
> <ts> could be an expression that evaluates to a timestamp. E.g.:
> {noformat}
> DESCRIBE HISTORY <table> FROM now() - interval 1 days;{noformat}
> {{BETWEEN}}, {{AND}}, and {{FROM}} are keywords in the SQL standard already.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
