[ https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823654#comment-16823654 ]
Hive QA commented on HIVE-21631: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12966675/HIVE-21631.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 18 failed/errored test(s), 15823 tests executed *Failed tests:* {noformat} TestCachedStore - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestCatalogCaching - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestDataSourceProviderFactory - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestDeadline - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestHiveMetaStoreGetMetaConf - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestHiveMetaStoreTimeout - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestHiveMetaStoreTxns - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestMarkPartition - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestMarkPartitionRemote - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestMetaStoreEventListenerOnlyOnCommit - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestMetaStoreEventListenerWithOldConf - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestMetaStoreInitListener - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestMetaStoreListenersError - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestMetaStoreSchemaInfo - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestObjectStore - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestObjectStoreSchemaMethods - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestRemoteHiveMetaStoreZKBindHost - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestTableIterable - did not produce a TEST-*.xml file (likely timed out) (batchId=231) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/17008/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/17008/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-17008/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 18 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12966675 - PreCommit-HIVE-Build > 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 > Attachments: HIVE-21631.patch > > > 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)