[ 
https://issues.apache.org/jira/browse/HIVE-20908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16887468#comment-16887468
 ] 

Ashutosh Chauhan commented on HIVE-20908:
-----------------------------------------

I dont see how this patch will improve perf, if anything it might make it 
worse. You are still making a call per DB, so nothing changes there but now 
instead of passing name you are passing pattern, so you will get more table 
objects then necessary. 
Suggestion on HIVE-19432 was to create a pattern on dbNames and then make a 
*single* metastoreClient.getTableMeta() to get all table objects in one shot, 
instead of per DB.

> Avoid multiple getTableMeta calls during GetTablesOperation.
> ------------------------------------------------------------
>
>                 Key: HIVE-20908
>                 URL: https://issues.apache.org/jira/browse/HIVE-20908
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>    Affects Versions: 3.1.1
>            Reporter: Rajkumar Singh
>            Assignee: Rajkumar Singh
>            Priority: Minor
>              Labels: performance
>         Attachments: HIVE-20908.patch
>
>
> following HIVE-19432, we are doing getTableMeta for each authorized db 
> instead of that we can pass pattern for metastore.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

Reply via email to