[
https://issues.apache.org/jira/browse/HIVE-7575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14979848#comment-14979848
]
Navis commented on HIVE-7575:
-----------------------------
[~aihuaxu] Wanted method signature to be simplistic but so be it. (used
TableMetaData by mistake. I'll change it to TableMeta in next patch)
bq. To Yongzhi's question: when we have many databases, the performance of the
original getTables could be bad since we are making at least one trip for each
database. Is that right?
It would be one of the root cause. But seeing HIVE-11702, it takes much time
though getSchema(null) uses just one call to metastore. Pattern matching query
seems much more expensive than expected(Even with simple * pattern)
> GetTables thrift call is very slow
> ----------------------------------
>
> Key: HIVE-7575
> URL: https://issues.apache.org/jira/browse/HIVE-7575
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 0.12.0, 0.13.0
> Reporter: Ashu Pachauri
> Assignee: Navis
> Attachments: HIVE-7575.1.patch.txt, HIVE-7575.2.patch.txt,
> HIVE-7575.3.patch.txt, HIVE-7575.4.patch.txt, HIVE-7575.5.patch.txt,
> HIVE-7575.6.patch.txt
>
>
> The GetTables thrift call takes a long time when the number of table is large.
> With around 5000 tables, the call takes around 80 seconds compared to a "Show
> Tables" query on the same HiveServer2 instance which takes 3-7 seconds.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
