[ https://issues.apache.org/jira/browse/HIVE-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17803231#comment-17803231 ]
Dmitriy Fingerman commented on HIVE-27980: ------------------------------------------ FYI [~aturoczy], [~dkuzmenko] > Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax > -------------------------------------------------------------- > > Key: HIVE-27980 > URL: https://issues.apache.org/jira/browse/HIVE-27980 > Project: Hive > Issue Type: New Feature > Reporter: Dmitriy Fingerman > Priority: Major > > Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. > {code:java} > ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} > Add support for OPTIMIZE TABLE syntax. Example: > {code:java} > OPTIMIZE TABLE name > REWRITE DATA [USING BIN_PACK] > [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = <value> [, ... ] ) ] > WHERE category = 'c1' {code} > This syntax will be inline with Impala. > Also, OPTIMIZE command supports more syntax than only compaction. > -- This message was sent by Atlassian Jira (v8.20.10#820010)