[HIVE-25463] Add support to standalone Hive metastore for bulk dropping partitions out of the box

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.2
• Component/s: Standalone Metastore
• Assignee: Unassigned
• Reporter: Chinmay Kulkarni
• Created: 17/Aug/21 19:33
• Updated: 17/Aug/21 19:34

Description

Today for setups that use standalone metastore, we set the following:

<property>
  <name>metastore.expression.proxy</name>
  <value>org.apache.hadoop.hive.metastore.DefaultPartitionExpressionProxy</value>
</property>

However, DefaultPartitionExpressionProxy throws UnsupportedOperationException throughout, thus preventing any partition pruning to be successful.

The effect of this is, other projects that rely on just standalone Hive Metastore (for example Trino) are unable to do things like invoke bulk partition drops using say, HiveMetaStore.drop_partitions_req via a Thrift client.

We should implement a separate PartitionExpressionProxy implementation for such clients for use with standalone HMS. Note that an implementation like PartitionExpressionForMetastore cannot be used in such cases since standalone HMS installs will/should not have hive-exec dependencies.

Please refer to Trino issue#7249 for more context