[HIVE-28322] The documentation page for Hive Transactions incorrectly references a non-existent property `hive.compactor.cleaner.on`

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Qiheng He
• Created: 11/Jun/24 17:41
• Updated: 12/Jun/24 07:05

Description

• The documentation page for Hive Transactions incorrectly references a non-existent property hive.compactor.cleaner.on. Refer to the Apache Hive Configuration Properties at https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.compactor.cleaner.on and https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=283118453 , which clarify that this property is deprecated and should be replaced with metastore.compactor.cleaner.on.

• When attempting to execute the SQL command within a Docker environment using the apache/hive:4.0.0 image,

  SET hive.compactor.cleaner.on=true;
  

• DataGrip responds with an exception:

  [42000][1] Error while processing statement: Hive configuration property hive.compactor.cleaner.on does not exist.
  

• The cited page https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=283118453 correctly notes the deprecation of hive.compactor.cleaner.on, suggesting its substitution with metastore.compactor.cleaner.on; however, it should not incorrectly persist in describing a property that is no longer valid. Additional context on this matter was discussed in https://github.com/apache/shardingsphere/pull/31526 .