[ https://issues.apache.org/jira/browse/TRAFODION-2733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16293000#comment-16293000 ]
ASF GitHub Bot commented on TRAFODION-2733: ------------------------------------------- GitHub user selvaganesang opened a pull request: https://github.com/apache/incubator-trafodion/pull/1351 [TRAFODION-2733] BMO quota changes Fix for hive/TEST009 regression failure with commit 375eeeab7a You can merge this pull request into a Git repository by running: $ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-2733 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/1351.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 #1351 ---- commit d189467f396a2831e6fc0aef1a8799a7e7fa9f6d Author: selvaganesang <selva.govindara...@esgyn.com> Date: 2017-12-15T18:35:57Z [TRAFODION-2733] BMO quota changes Fix for hive/TEST009 regression failure with commit 375eeeab7a ---- > Provide an improved memory quota assignment for big memory operators (BMO) > -------------------------------------------------------------------------- > > Key: TRAFODION-2733 > URL: https://issues.apache.org/jira/browse/TRAFODION-2733 > Project: Apache Trafodion > Issue Type: Improvement > Components: sql-cmp, sql-exe > Affects Versions: 2.3-incubating > Reporter: Selvaganesan Govindarajan > Assignee: Selvaganesan Govindarajan > Fix For: 2.3-incubating > > > The big memory operators in Trafodion are HashJoin, HashGroupBy and Sort. > Trafodion deploys multiple executor server processes (ESPs) to execute a > query via its data flow architecture. Each ESPs can have an instance of this > BMO operator. Currently, each instance of this operator can potentially have > memory quota of 800 MB assigned to do its BMO operation. However, the memory > allocation is usually limited by the memory pressure when this BMO attempts > to allocate memory within the assigned quota. The assignment doesn't depend > upon the estimation of memory needed by this operation. > Improvement needed in BMO memory assignment are: > 1. Limit the memory quota assignment for these BMO operations per node > 2. Memory quota assigned taking into consideration estimated memory needed > at every operator. > 3. Ensure that the BMO gets the minimum memory needed at least to function > smoothly -- This message was sent by Atlassian JIRA (v6.4.14#64029)