[IMPALA-11116] DESCRIBE HISTORY should be parameterized

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.1.0
• Component/s: Frontend
• Labels: impala-iceberg
• Epic Color: ghx-label-2
• Assignee: Tamas Mate
• Reporter: Zoltán Borók-Nagy
• Created: 11/Feb/22 09:59
• Updated: 17/Apr/22 12:29
• Resolved: 25/Mar/22 17:48

Description

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.:

DESCRIBE HISTORY <table> BETWEEN <ts1> AND <ts2>;
DESCRIBE HISTORY <table> FROM <ts>;

<ts> could be an expression that evaluates to a timestamp. E.g.:

DESCRIBE HISTORY <table> FROM now() - interval 1 days;

BETWEEN, AND, and FROM are keywords in the SQL standard already.

Issue Links

• causes: IMPALA-11203 Build failure caused by missing ExecutorMembershipSnapshot import