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

[Sankar Hariappan (JIRA)]

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)