[HIVE-26661] Support partition filter for char and varchar types on Hive metastore

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.0-alpha-1
• Fix Version/s: 4.0.0-beta-1
• Component/s: Hive
• Labels: pull-request-available
• Target Version/s: 4.0.0-alpha-1
• Assignee: Wechar
• Reporter: Wechar
• Created: 23/Oct/22 11:25
• Updated: 15/Aug/23 06:33
• Resolved: 26/Jan/23 20:27

Description

HMS stores partition value as string in backend database, so it supports "equal filter" for string (include date type) and integer types, and other filter (for example greater than > ) for only string type.

The char and varchar types can also considered as string, and we can support the partition filter for them on HMS.

Issue Links

• causes: HIVE-27168 Use basename of the datatype when fetching partition metadata using partition filters
• links to: GitHub Pull Request #3696