[
https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821476#comment-16821476
]
Jesus Camacho Rodriguez edited comment on HIVE-21631 at 4/18/19 8:45 PM:
-------------------------------------------------------------------------
No need to have this as a sub-task under the umbrella for materialized views
enhancements that was already closed, I've converted it to issue.
was (Author: jcamachorodriguez):
No need to have this as a sub-task under the umbrella for materialized views
enhancements that was already closed, I've moved it to issue.
> Enhance metastore API to allow bulk-loading materialized views
> --------------------------------------------------------------
>
> Key: HIVE-21631
> URL: https://issues.apache.org/jira/browse/HIVE-21631
> Project: Hive
> Issue Type: Bug
> Components: Materialized views, Metastore
> Affects Versions: 3.2.0, 3.1.1
> Reporter: Craig Condit
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
>
> Currently, every query in HS2 results in a metastore call per database to
> retrieve all materialized views. This causes severe performance degradation
> on multi-tenant clusters with thousands of databases (very similar to how the
> old get_function() metastore call didn't scale).
> We should add a metastore call which can retrieve all materialized view
> definitions at once (for all DBs) so that we don't have to make thousands of
> metastore calls per query.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
