[
https://issues.apache.org/jira/browse/HIVE-16520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15991095#comment-15991095
]
Hive QA commented on HIVE-16520:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12865745/HIVE-16520.2.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 27 failed/errored test(s), 10635 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestAccumuloCliDriver.testCliDriver[accumulo_index]
(batchId=225)
org.apache.hadoop.hive.cli.TestHBaseCliDriver.org.apache.hadoop.hive.cli.TestHBaseCliDriver
(batchId=94)
org.apache.hadoop.hive.metastore.cache.TestCachedStore.testSharedStoreDb
(batchId=194)
org.apache.hadoop.hive.metastore.cache.TestCachedStore.testSharedStorePartition
(batchId=194)
org.apache.hadoop.hive.metastore.cache.TestCachedStore.testSharedStoreTable
(batchId=194)
org.apache.hive.beeline.cli.TestHiveCli.testCmd (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testDatabaseOptions (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testErrOutput (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testHelp (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testInValidCmd (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testInvalidDatabaseOptions (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testInvalidOptions (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testInvalidOptions2 (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testNoErrorDB (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testSetHeaderValue (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testSetPromptValue (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testSourceCmd (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testSourceCmd2 (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testSourceCmd3 (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testSqlFromCmd (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testSqlFromCmdWithDBName (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testUseCurrentDB1 (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testUseCurrentDB2 (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testUseCurrentDB3 (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testUseInvalidDB (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testVariables (batchId=173)
org.apache.hive.beeline.cli.TestHiveCli.testVariablesForSource (batchId=173)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/4961/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/4961/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-4961/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 27 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12865745 - PreCommit-HIVE-Build
> Cache hive metadata in metastore
> --------------------------------
>
> Key: HIVE-16520
> URL: https://issues.apache.org/jira/browse/HIVE-16520
> Project: Hive
> Issue Type: New Feature
> Components: Metastore
> Reporter: Daniel Dai
> Assignee: Daniel Dai
> Attachments: HIVE-16520-1.patch, HIVE-16520.2.patch,
> HIVE-16520.3.patch, HIVE-16520-proto-2.patch, HIVE-16520-proto.patch
>
>
> During Hive 2 benchmark, we find Hive metastore operation take a lot of time
> and thus slow down Hive compilation. In some extreme case, it takes much
> longer than the actual query run time. Especially, we find the latency of
> cloud db is very high and 90% of total query runtime is waiting for metastore
> SQL database operations. Based on this observation, the metastore operation
> performance will be greatly enhanced if we have a memory structure which
> cache the database query result.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
