[
https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Craig Condit updated HIVE-21631:
--------------------------------
Issue Type: Sub-task (was: Improvement)
Parent: HIVE-14484
> 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: Sub-task
> Components: Materialized views, Metastore
> Affects Versions: 3.2.0, 3.1.1
> Reporter: Craig Condit
> 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)
