This is an automated email from the ASF dual-hosted git repository. joemcdonnell pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/impala.git
commit 39cab9adeeedabf2904e2daf7b446a25a3f161e2 Author: Peter Rozsa <[email protected]> AuthorDate: Fri Sep 20 11:28:39 2024 +0200 IMPALA-13220: Docs for Iceberg DROP PARTITION This patch adds a new section to the Iceberg topic about DROP PARTITION. Change-Id: I45ea95d94ff9785309911c71b5dcf7c13c05b3c4 Reviewed-on: http://gerrit.cloudera.org:8080/21833 Tested-by: Impala Public Jenkins <[email protected]> Reviewed-by: Noemi Pap-Takacs <[email protected]> Reviewed-by: Daniel Becker <[email protected]> --- docs/topics/impala_iceberg.xml | 34 +++++++++++++++++++++++++++++++++- 1 file changed, 33 insertions(+), 1 deletion(-) diff --git a/docs/topics/impala_iceberg.xml b/docs/topics/impala_iceberg.xml index b333320b3..e82dc8a0d 100644 --- a/docs/topics/impala_iceberg.xml +++ b/docs/topics/impala_iceberg.xml @@ -490,8 +490,40 @@ DELETE FROM ice_t where i = 3; </conbody> </concept> + <concept id="iceberg_drop_partition"> + <title>Dropping partitions from Iceberg tables</title> + <conbody> + <p> + Since <keyword keyref="impala44"/> Impala is able to run <codeph>ALTER TABLE DROP PARTITION</codeph> statements. E.g.: + <codeblock> +ALTER TABLE ice_t DROP PARTITION (i = 3); +ALTER TABLE ice_t DROP PARTITION (day(date_col) < '2024-10-01'); +ALTER TABLE ice_t DROP PARTITION (year(timestamp_col) = '2024'); + </codeblock> + </p> + <p> + Any non-identity transforms must be included in the partition selector like <codeph>(day(date_col))</codeph>. Operands for filtering date and + timestamp-based columns with transforms must be provided as strings, for example: <codeph>(day(date_col) = '2024-10-01')</codeph>. + This is a metadata-only operation, the datafiles targeted by the deleted partitions do not get purged or removed from the filesystem, + only a new snapshot is getting created with the remaining partitions. + </p> + <p> + Limitations: + <ul> + <li>Binary filter predicates must consist of one partition selector and one constant expression; + e.g.: <codeph>(day(date_col) = '2024-10-01')</codeph> is allowed, but <codeph>(another_date_col = date_col)</codeph> is not allowed.</li> + <li>Filtering expressions must target the latest partition spec of the table.</li> + </ul> + </p> + <p> + More information about the <codeph>ALTER TABLE DROP PARTITION</codeph> statement can be found at + <xref href="impala_alter_table.xml"/>. + </p> + </conbody> + </concept> + <concept id="iceberg_update"> - <title>Updating data int Iceberg tables</title> + <title>Updating data in Iceberg tables</title> <conbody> <p> Since <keyword keyref="impala44"/> Impala is able to run <codeph>UPDATE</codeph> statements against
