[jira] [Comment Edited] (HIVE-16520) Cache hive metadata in metastore

["Thejas M Nair (JIRA)" <ji...@apache.org>]

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

Thejas M Nair edited comment on HIVE-16520 at 4/25/17 5:36 PM:
---------------------------------------------------------------

[~daijy] Can you please include a reviewboard link or github pull request ?



was (Author: thejas):
[~daijy] Can you please include a reviewboard link github pull request ?


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