[HIVE-20646] Partition filter condition is not pushed down to metastore query if it has IS NOT NULL.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0, 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: HiveServer2, Standalone Metastore
• Labels: Metastore Performance pull-request-available
• Target Version/s: 4.0.0
• Assignee: Sankar Hariappan
• Reporter: Sankar Hariappan
• Created: 27/Sep/18 09:22
• Updated: 17/Nov/22 08:54
• Resolved: 06/Oct/18 08:16

Description

If the partition filter condition has "is not null" then the filter query isn't getting pushed to the SQL query in RDMBS.
This slows down metastore api calls for getting list of partitions with filter condition.

This condition gets added by optimizer in many cases so this is affecting many queries.

Issue Links

• links to: GitHub Pull Request #441