Configuring compaction using table properties
You see how to configure compaction using table properties and learn about the advantage of using this method of configuration.
Set table properties to adjust the compaction initiator properties.
ALTER TABLE mydb.mytable
SET TBLPROPERTIES (
'compactorthreshold.hive.compactor.delta.pct.threshold'='0.2f',
'compactorthreshold.hive.compactor.delta.num.threshold'='20');
These properties change thresholds, as the names imply: the deltas/base size percentage
override threshold and the number of deltas threshold.