Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-27980

Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0
    • None

    Description

      Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below.

      ALTER TABLE name COMPACT MAJOR [AND WAIT] 

      Add support for OPTIMIZE TABLE syntax. Example:

      OPTIMIZE TABLE name
      REWRITE DATA [USING BIN_PACK]
      [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = <value> [, ... ] ) ]
      WHERE category = 'c1' 

      This syntax will be inline with Impala.

      Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations.

       

      Attachments

        Issue Links

          Activity

            People

              difin Dmitriy Fingerman
              difin Dmitriy Fingerman
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: