You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sankar Hariappan (JIRA)" <ji...@apache.org> on 2018/09/27 09:23:00 UTC
[jira] [Assigned] (HIVE-20646) Partition filter condition is not
pushed down to metastore query if it has IS NOT NULL.
[ https://issues.apache.org/jira/browse/HIVE-20646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sankar Hariappan reassigned HIVE-20646:
---------------------------------------
> 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
> Priority: Major
> Labels: Performance, Metastore
>
> 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)