[HIVE-15920] Implement a blocking version of a command to compact

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0
• Component/s: Transactions
• Labels: TODOC2.2
• Target Version/s: 2.2.0
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 14/Feb/17 22:22
• Updated: 21/Jul/17 18:36
• Resolved: 07/Mar/17 19:01

Description

currently

alter table AcidTable compact 'major'

is supported which enqueues a msg to compact.

Would be nice for testing and script building to support

 
alter table AcidTable compact 'major' blocking

perhaps another variation is to block until either compaction is done or until cleaning is finished.

DDLTask.compact() gets a request id back so it can then just block and wait for it using some new API

may also be useful to let users compact all partitions but only if a separate queue has been set up for compaction jobs.
The later is because with a 1M partition table, this may create very many jobs and saturate the cluster.
This probably requires HIVE-12376 to make sure the compaction queue does the throttling, not the number of worker threads

Issue Links

• depends upon: HIVE-13353 SHOW COMPACTIONS should support filtering options