[jira] [Commented] (HUDI-2116) sync 10w partitions to hive by using HiveSyncTool lead to the oom of hive MetaStore

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

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

ASF GitHub Bot commented on HUDI-2116:
--------------------------------------

xiarixiaoyao opened a new pull request #3209:
URL: https://github.com/apache/hudi/pull/3209


   …the oom of hive MetaStore
   
   ## *Tips*
   - *Thank you very much for contributing to Apache Hudi.*
   - *Please review https://hudi.apache.org/contributing.html before opening a pull request.*
   
   ## What is the purpose of the pull request
   
   <html>
   <body>
   <!--StartFragment--><p>when we try to sync 10w partitions to hive by using HiveSyncTool lead to the oom of hive MetaStore。<br /> &nbsp;<br /> here is a stress test for HiveSyncTool</p>
   <p>env：</p>
   <p>hive metastore&nbsp;-Xms16G -Xmx16G</p>
   <p>hive.metastore.client.socket.timeout=10800</p>
   <p>&nbsp;</p>
   <div class="table-wrap">
   
   
   partitionNum | time consume
   -- | --
   100 | 37s
   1000 | 168s
   5000 | 1830s
   10000 | timeout
   100000 | hive metastore oom
   
   
   </div>
   <p>HiveSyncTools&nbsp; sync all partitions to hive metastore at once。 when the partitions num is large ，it puts a lot of pressure on hive metastore。 for large partition num we should support batch sync 。</p><!--EndFragment-->
   </body>
   </html>
   ## Brief change log
   
   *(for example:)*
     - *Modify AnnotationLocation checkstyle rule in checkstyle.xml*
   
   ## Verify this pull request
   
   UT added
   
   ## Committer checklist
   
    - [ ] Has a corresponding JIRA in PR title & commit
    
    - [ ] Commit message is descriptive of the change
    
    - [ ] CI is green
   
    - [ ] Necessary doc changes done or have another open PR
          
    - [ ] For large changes, please consider breaking it into sub-tasks under an umbrella JIRA.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


>  sync 10w partitions to hive by using HiveSyncTool lead to the oom of hive MetaStore
> ------------------------------------------------------------------------------------
>
>                 Key: HUDI-2116
>                 URL: https://issues.apache.org/jira/browse/HUDI-2116
>             Project: Apache Hudi
>          Issue Type: Bug
>          Components: Hive Integration
>    Affects Versions: 0.8.0
>         Environment: hive3.1.1
> hadoop 3.1.1
>            Reporter: tao meng
>            Assignee: tao meng
>            Priority: Major
>             Fix For: 0.10.0
>
>
> when we try to sync 10w partitions to hive by using HiveSyncTool lead to the oom of hive MetaStore。
>  
> here is a stress test for HiveSyncTool
> env： 
> hive metastore -Xms16G -Xmx16G
> hive.metastore.client.socket.timeout=10800
>  
> ||partitionNum||time consume||
> |100|37s|
> |1000|168s|
> |5000|1830s|
> |10000|timeout|
> |100000|hive metastore oom|
> HiveSyncTools  sync all partitions to hive metastore at once。 when the partitions num is large ，it puts a lot of pressure on hive metastore。 for large partition num we should support batch sync 。
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)