[
https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825453#comment-16825453
]
Jesus Camacho Rodriguez commented on HIVE-21631:
------------------------------------------------
[~ashutoshc], [~vgarg], could you take a look?
https://github.com/apache/hive/pull/606
Thanks
> 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
> Labels: pull-request-available
> Attachments: HIVE-21631.patch, HIVE-21631.patch, HIVE-21631.patch,
> HIVE-21631.patch
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
