You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2015/09/08 06:40:45 UTC

[jira] [Updated] (HIVE-11702) GetSchemas thrift call is slow on scale of 1000+ databases

     [ https://issues.apache.org/jira/browse/HIVE-11702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Navis updated HIVE-11702:
-------------------------
    Attachment: HIVE-11702.1.patch.txt

Could you do it again with the patch attached? The only difference between GetSchemas and "show tables" is that the latter does not use pattern matching when "schema" param is null.

> GetSchemas thrift call is slow on scale of 1000+ databases
> ----------------------------------------------------------
>
>                 Key: HIVE-11702
>                 URL: https://issues.apache.org/jira/browse/HIVE-11702
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>    Affects Versions: 1.1.1
>            Reporter: Jenny Kim
>         Attachments: HIVE-11702.1.patch.txt
>
>
> Similar to https://issues.apache.org/jira/browse/HIVE-7575 GetSchemas also starts to degrade in latency starting at the order of 1000+ databases, which returned in about 30 seconds.
> However, SHOW DATABASES on the same Hive instance returns within a few seconds.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)