[ 
https://issues.apache.org/jira/browse/HIVE-16520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15989246#comment-15989246
 ] 

ASF GitHub Bot commented on HIVE-16520:
---------------------------------------

GitHub user daijyc opened a pull request:

    https://github.com/apache/hive/pull/173

    HIVE-16520: Cache hive metadata in metastore

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/daijyc/hive master

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/hive/pull/173.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #173
    
----
commit 24fed179e00b1f323e218b2eba2c07ab5124a9e3
Author: Daniel Dai <[email protected]>
Date:   2017-04-28T00:08:11Z

    HIVE-16520: Cache hive metadata in metastore

----


> 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-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)

Reply via email to