Sankar Hariappan created HIVE-20646:
---------------------------------------
Summary: Partition filter condition is not pushed down to
metastore query if it has IS NOT NULL.
Key: HIVE-20646
URL: https://issues.apache.org/jira/browse/HIVE-20646
Project: Hive
Issue Type: Improvement
Components: HiveServer2, Standalone Metastore
Affects Versions: 4.0.0
Reporter: Sankar Hariappan
Assignee: Sankar Hariappan
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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)