Disable automatic compaction

You can disable automatic compaction of a particular Hive table by setting the NO_AUTO_COMPACTION property in TBLPROPERTIES of a table. 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');