Sakshi Bansal created HIVE-21202:
------------------------------------

             Summary: get_partitions_ps_with_auth() takes a long time with high 
number of partitions
                 Key: HIVE-21202
                 URL: https://issues.apache.org/jira/browse/HIVE-21202
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.1.1
            Reporter: Sakshi Bansal


 

On a table with 6000 partitions,

`get_partitions_ps_with_auth` takes around 130 seconds to fetch a list of 
partitions. 

 
{noformat}
HiveMetaStore::public List<Partition> get_partitions_ps_with_auth(final String 
db_name,
 final String tbl_name, final List<String> part_vals,
 final short max_parts, final String userName,
 final List<String> groupNames) 
{noformat}
 

Whereas, a combination of the following 2 APIs takes only 5 seconds in total. 

 
{noformat}
HiveMetaStore::public List<String> get_partition_names_ps(final String db_name,
 final String tbl_name, final List<String> part_vals, final short max_parts)
HiveMetaStore::public List<Partition> get_partitions_by_names(final String 
dbName,
 final String tblName, final List<String> partNames)
{noformat}
 

Note: Hive authorization is not enabled.

Please close as duplicate of https://issues.apache.org/jira/browse/HIVE-19715, 
if it aims at solving this problem as well.

  

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to