Disable automatic compaction

You can disable automatic compaction of a particular Hive table by setting a Hive table property. By default, compaction is enabled, so you must enter an ALTER TABLE command to disable it.

Disabling automatic compaction does not prevent you from performing manual compaction.

Start the Hive shell, and in the database of the target table, alter the TBLPROPERTIES.

ALTER TABLE my_t SET TBLPROPERTIES ('NO_AUTO_COMPACTION'='true');