[jira] [Created] (TRAFODION-2133) support Hive native data type CHAR
liu ming created TRAFODION-2133: --- Summary: support Hive native data type CHAR Key: TRAFODION-2133 URL: https://issues.apache.org/jira/browse/TRAFODION-2133 Project: Apache Trafodion Issue Type: Sub-task Components: sql-cmp, sql-general Reporter: liu ming This JIRA is not too complex, so a good beginner's JIRA. support CHAR data type from Hive DDL. create table tbl_char { c1 char(10), c2 char(20) }; in hive, and insert some value, it should be able to read from Trafodion via sqlci: select * from hive.hive.tbl_char -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (TRAFODION-2126) package files should indicate which OS/processor they are built for
[ https://issues.apache.org/jira/browse/TRAFODION-2126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steve Varnau resolved TRAFODION-2126. - Resolution: Fixed Fix Version/s: 2.1-incubating > package files should indicate which OS/processor they are built for > --- > > Key: TRAFODION-2126 > URL: https://issues.apache.org/jira/browse/TRAFODION-2126 > Project: Apache Trafodion > Issue Type: Sub-task > Components: Build Infrastructure >Reporter: Steve Varnau >Assignee: Steve Varnau > Fix For: 2.1-incubating > > > built package files (server and client) should indicate whether they are > built for RH6 or RH7. > Should also add processor type (e.g., x86_64) in case community wants to > build on more than one. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (TRAFODION-1977) Merge 2.0 fixes forward to master branch
[ https://issues.apache.org/jira/browse/TRAFODION-1977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steve Varnau resolved TRAFODION-1977. - Resolution: Fixed Fix Version/s: 2.1-incubating All 2.0.1 content is merged forward to 2.1 (master branch). > Merge 2.0 fixes forward to master branch > > > Key: TRAFODION-1977 > URL: https://issues.apache.org/jira/browse/TRAFODION-1977 > Project: Apache Trafodion > Issue Type: Bug >Affects Versions: 2.1-incubating >Reporter: Steve Varnau >Assignee: Steve Varnau > Fix For: 2.1-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2047) add SQL syntax support to INTERSECT
[ https://issues.apache.org/jira/browse/TRAFODION-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15397842#comment-15397842 ] ASF GitHub Bot commented on TRAFODION-2047: --- GitHub user traflm opened a pull request: https://github.com/apache/incubator-trafodion/pull/623 [TRAFODION-2047] add support of SQL syntax INTERSECT support of SQL syntax INTERSECT, INTERSECT DISTINCT not able to support INTERSECT ALL, which will raise an error. TPCDS quries only need INTERSECT, and the semantics is same, while two child input of INTERSECT must have same number of columns and in same order and each column type must be matching. Also a minor change to TM Makefile to include log4cxx header file path, if log4cxx is not installed into system include path. You can merge this pull request into a Git repository by running: $ git pull https://github.com/traflm/incubator-trafodion TRAFODION-2047-1 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/623.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 #623 commit 23fe6d5a6c5c9832bf85bb2348bba5d75f91c8ea Author: Liu Ming Date: 2016-07-28T16:58:20Z [TRAFODION-2047] add support of SQL syntax INTERSECT > add SQL syntax support to INTERSECT > --- > > Key: TRAFODION-2047 > URL: https://issues.apache.org/jira/browse/TRAFODION-2047 > Project: Apache Trafodion > Issue Type: New Feature >Reporter: liu ming >Assignee: liu ming > Fix For: 2.1-incubating > > > INTERSECT is a common SQL syntax. > Trafodion should support it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2130) Incorrect subquery transformation for tables w/o key
[ https://issues.apache.org/jira/browse/TRAFODION-2130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15397884#comment-15397884 ] ASF GitHub Bot commented on TRAFODION-2130: --- GitHub user zellerh opened a pull request: https://github.com/apache/incubator-trafodion/pull/624 [TRAFODION-2130] Incorrect subquery unnesting A missing ">" character caused us to do an unnesting transformation without having uniqueness constraint on the main query. Note that this is a rare case, since most tables have unique columns and since the code tries to get those unique columns if they are not already included. You can merge this pull request into a Git repository by running: $ git pull https://github.com/zellerh/incubator-trafodion bug/fix Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/624.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 #624 commit 1ca26fc8fbfa9cb12dd37f453b71034db3372c82 Author: Hans Zeller Date: 2016-07-28T17:39:55Z [TRAFODION-2130] Incorrect subquery unnesting A missing ">" character caused us to do an unnesting transformation without having uniqueness constraint on the main query. Note that this is a rare case, since most tables have unique columns and since the code tries to get those unique columns if they are not already included. > Incorrect subquery transformation for tables w/o key > > > Key: TRAFODION-2130 > URL: https://issues.apache.org/jira/browse/TRAFODION-2130 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 1.2-incubating >Reporter: Hans Zeller >Assignee: Hans Zeller > > Some of the subquery unnesting transformations rely on a unique key on the > result of the main query. It turns out, however, that the transformation > happens even if there is no unique key. Example: > select * > from (values (1,1), (1,1), (2,2)) T(a,b) > where t.a in (select max(a) > from (values (1,1), (1,1), (3,3)) S(a,b) > where S.b = T.b); > This should return two rows, but it actually just returns one, because it > does not include a unique key for the main query, T. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2128) install/.gitignore file incomplete
[ https://issues.apache.org/jira/browse/TRAFODION-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398010#comment-15398010 ] ASF GitHub Bot commented on TRAFODION-2128: --- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/622 > install/.gitignore file incomplete > -- > > Key: TRAFODION-2128 > URL: https://issues.apache.org/jira/browse/TRAFODION-2128 > Project: Apache Trafodion > Issue Type: Bug >Reporter: Steve Varnau >Assignee: Steve Varnau > > missing DISCLAIMER generated file. > This slipped through since jenkins automation is only checking core and dcs > instead of entire workspace. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2047) add SQL syntax support to INTERSECT
[ https://issues.apache.org/jira/browse/TRAFODION-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398060#comment-15398060 ] ASF GitHub Bot commented on TRAFODION-2047: --- Github user zellerh commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/623#discussion_r72684626 --- Diff: core/sql/optimizer/BindRelExpr.cpp --- @@ -717,7 +717,7 @@ static ItemExpr *intersectColumns(const RETDesc &leftTable, ItemExpr *leftExpr = leftTable.getValueId(i).getItemExpr(); ItemExpr *rightExpr = rightTable.getValueId(i).getItemExpr(); BiRelat *compare = new (bindWA->wHeap()) - BiRelat(ITM_EQUAL, leftExpr, rightExpr); + BiRelat(ITM_EQUAL, leftExpr, rightExpr, TRUE); --- End diff -- Here are two things I wonder: First, would it make sense to replace the TRUE here with "leftExpr->getValueId().getType().supportsSQLnull() && rightExpr->getValueId().getType().supportsSQLnull()". I'm not sure we have optimizations elsewhere that set the "special nulls" semantics back to FALSE if one of the operands it not nullable. Second, I wonder whether we have bugs elsewhere in the code that may not check for the "special nulls" semantics. For example, hash and merge joins probably can't use such predicates as equi-join predicates - one of the reasons for the optimization above. When I look at method ItemExpr::isAnEquiJoinPredicate() in core/sql/optimizer/OptItemExpr.cpp, I don't see a check for that. You have an example with a NULL value that is working, so hopefully this is not an issue, but I'm not sure how and why it works. > add SQL syntax support to INTERSECT > --- > > Key: TRAFODION-2047 > URL: https://issues.apache.org/jira/browse/TRAFODION-2047 > Project: Apache Trafodion > Issue Type: New Feature >Reporter: liu ming >Assignee: liu ming > Fix For: 2.1-incubating > > > INTERSECT is a common SQL syntax. > Trafodion should support it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2047) add SQL syntax support to INTERSECT
[ https://issues.apache.org/jira/browse/TRAFODION-2047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398074#comment-15398074 ] ASF GitHub Bot commented on TRAFODION-2047: --- Github user zellerh commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/623#discussion_r72685632 --- Diff: core/sql/optimizer/BindRelExpr.cpp --- @@ -717,7 +717,7 @@ static ItemExpr *intersectColumns(const RETDesc &leftTable, ItemExpr *leftExpr = leftTable.getValueId(i).getItemExpr(); ItemExpr *rightExpr = rightTable.getValueId(i).getItemExpr(); BiRelat *compare = new (bindWA->wHeap()) - BiRelat(ITM_EQUAL, leftExpr, rightExpr); + BiRelat(ITM_EQUAL, leftExpr, rightExpr, TRUE); --- End diff -- My hope is that hash and merge join are carefully implemented to make this type of equals predicate with the "special nulls" semantics work as an equi-join predicate. If we hash/sort NULL values as regular values, and preserve the "special nulls" semantics for the actual comparison that's done in the hash/merge join, it might work just fine, and hopefully your example proves that this is indeed how it's implemented. The easiest way to check this is probably an EXPLAIN and a SHOWPLAN. If you want to send me this info for the example you added to the regression test (the one that includes a NULL value), I can take a look. > add SQL syntax support to INTERSECT > --- > > Key: TRAFODION-2047 > URL: https://issues.apache.org/jira/browse/TRAFODION-2047 > Project: Apache Trafodion > Issue Type: New Feature >Reporter: liu ming >Assignee: liu ming > Fix For: 2.1-incubating > > > INTERSECT is a common SQL syntax. > Trafodion should support it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Work started] (TRAFODION-2134) Change the overflow_mode to 'DISK' by default
[ https://issues.apache.org/jira/browse/TRAFODION-2134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2134 started by Selvaganesan Govindarajan. > Change the overflow_mode to 'DISK' by default > - > > Key: TRAFODION-2134 > URL: https://issues.apache.org/jira/browse/TRAFODION-2134 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-exe >Affects Versions: 2.1-incubating >Reporter: Selvaganesan Govindarajan >Assignee: Selvaganesan Govindarajan > Fix For: 2.1-incubating > > Original Estimate: 24h > Remaining Estimate: 24h > > In queries involving Block Memory Operators (BMOs), Trafodion can overflow > the data from the data flow into scratch files. These scratch files are > currently being memory mapped which puts pressure on the memory usage on the > node when there is large amount of overflow. The default needs to be changed > to DISK -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (TRAFODION-2134) Change the overflow_mode to 'DISK' by default
Selvaganesan Govindarajan created TRAFODION-2134: Summary: Change the overflow_mode to 'DISK' by default Key: TRAFODION-2134 URL: https://issues.apache.org/jira/browse/TRAFODION-2134 Project: Apache Trafodion Issue Type: Bug Components: sql-exe Affects Versions: 2.1-incubating Reporter: Selvaganesan Govindarajan Assignee: Selvaganesan Govindarajan Fix For: 2.1-incubating In queries involving Block Memory Operators (BMOs), Trafodion can overflow the data from the data flow into scratch files. These scratch files are currently being memory mapped which puts pressure on the memory usage on the node when there is large amount of overflow. The default needs to be changed to DISK -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2131) UPDATE STATS cores, buffer overrun, on TINYINT and small INTERVAL cols
[ https://issues.apache.org/jira/browse/TRAFODION-2131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398169#comment-15398169 ] David Wayne Birdsall commented on TRAFODION-2131: - Anoop suggested a simpler fix. The CLI does support returning a single-byte integer for TINYINT data types, but it is turned off by default as not all clients support it yet. One can turn it on by using CQD TRAF_TINYINT_RETURN_VALUES 'ON'. Turning this on cured the buffer overrun. Also, I experimented with UPDATE STATS on BOOLEAN and LARGEINT UNSIGNED columns. The LARGEINT UNSIGNED also failed with a buffer overrun. Again, there is a CQD that tells the CLI to return it as an 8-byte value; that is CQD TRAF_LARGEINT_UNSIGNED_IO 'ON'. Turning this on cured the problem. For BOOLEAN, the ustats code was lacking support for this data type. So, I added it. > UPDATE STATS cores, buffer overrun, on TINYINT and small INTERVAL cols > -- > > Key: TRAFODION-2131 > URL: https://issues.apache.org/jira/browse/TRAFODION-2131 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.1-incubating > Environment: All >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (TRAFODION-2128) install/.gitignore file incomplete
[ https://issues.apache.org/jira/browse/TRAFODION-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steve Varnau resolved TRAFODION-2128. - Resolution: Fixed Fix Version/s: 2.1-incubating > install/.gitignore file incomplete > -- > > Key: TRAFODION-2128 > URL: https://issues.apache.org/jira/browse/TRAFODION-2128 > Project: Apache Trafodion > Issue Type: Bug >Reporter: Steve Varnau >Assignee: Steve Varnau > Fix For: 2.1-incubating > > > missing DISCLAIMER generated file. > This slipped through since jenkins automation is only checking core and dcs > instead of entire workspace. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2128) install/.gitignore file incomplete
[ https://issues.apache.org/jira/browse/TRAFODION-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398168#comment-15398168 ] Steve Varnau commented on TRAFODION-2128: - Have also made change in jenkins to run check for entire workspace. > install/.gitignore file incomplete > -- > > Key: TRAFODION-2128 > URL: https://issues.apache.org/jira/browse/TRAFODION-2128 > Project: Apache Trafodion > Issue Type: Bug >Reporter: Steve Varnau >Assignee: Steve Varnau > Fix For: 2.1-incubating > > > missing DISCLAIMER generated file. > This slipped through since jenkins automation is only checking core and dcs > instead of entire workspace. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2067) Support CDH 5.7
[ https://issues.apache.org/jira/browse/TRAFODION-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398217#comment-15398217 ] ASF GitHub Bot commented on TRAFODION-2067: --- GitHub user amandamoran opened a pull request: https://github.com/apache/incubator-trafodion/pull/625 Additional install changes to support TRAFODION-2067 You can merge this pull request into a Git repository by running: $ git pull https://github.com/amandamoran/incubator-trafodion TRAFODION-2034 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/625.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 #625 commit 57c992c96ee8b2bc954e7e6f911ae73ba16c727d Author: Amanda Moran Date: 2016-07-28T21:05:37Z Additional install changes to support TRAFODION-2067 > Support CDH 5.7 > --- > > Key: TRAFODION-2067 > URL: https://issues.apache.org/jira/browse/TRAFODION-2067 > Project: Apache Trafodion > Issue Type: Improvement > Environment: CDH 5.7 >Reporter: yuhong zhou >Assignee: mashengchen > > our bigdata platform CDH had been upgraded to 5.7. As tring to apply apache > trafodion as data warehouse based on bigdata distributions, we found current > release couldn;t support CDH 5.7 ,we wish next release can support it . > additionally, apache trafodion should be close to mainstream open soure > bigdata platform release, So, apache trafodion can be applied by more > companies as soon as possible -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2131) UPDATE STATS cores, buffer overrun, on TINYINT and small INTERVAL cols
[ https://issues.apache.org/jira/browse/TRAFODION-2131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398224#comment-15398224 ] ASF GitHub Bot commented on TRAFODION-2131: --- GitHub user DaveBirdsall opened a pull request: https://github.com/apache/incubator-trafodion/pull/626 [TRAFODION-2131] Fix UPDATE STATISTICS cores + some other issues 1. Fix cores caused by buffer overruns when doing UPDATE STATISTICS on INTERVAL YEAR(1) TO MONTH, TINYINT and LARGEINT UNSIGNED columns. Thanks to @anoopsharma00 for suggesting the use of CQDs to fix these issues. 2. Add support for BOOLEAN data type in UPDATE STATISTICS. 3. Fix a core in Cast::synthesizeType concerning INTERVAL and TINYINT data types. Thanks to @anoopsharma00 for the code for this fix. You can merge this pull request into a Git repository by running: $ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion2131 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/626.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 #626 commit ea655127dbbce1447cae5e27664fd44252c7c5b8 Author: Dave Birdsall Date: 2016-07-28T21:05:43Z [TRAFODION-2131] Fix USTATS cores + some other issues > UPDATE STATS cores, buffer overrun, on TINYINT and small INTERVAL cols > -- > > Key: TRAFODION-2131 > URL: https://issues.apache.org/jira/browse/TRAFODION-2131 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.1-incubating > Environment: All >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2129) Trafodion to avoid use of deprecated HBase APIs/Classes
[ https://issues.apache.org/jira/browse/TRAFODION-2129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398257#comment-15398257 ] ASF GitHub Bot commented on TRAFODION-2129: --- GitHub user selvaganesang opened a pull request: https://github.com/apache/incubator-trafodion/pull/627 [TRAFODION-2129] Trafodion to avoid use of deprecated HBase APIs/Classes References to the deprecated classes HConnection, HConnectionManager and HBaseAdmin are reworked to use Connection, ConnectionFactory and Admin classes respectively. A connection object is created and it is passed around to ensure that the same connection objects within the same process. Admin object is created and closed after its use immediately. You can merge this pull request into a Git repository by running: $ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-2129 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/627.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 #627 commit c27a0b1efd8149a123eaba0bdba1b77072977060 Author: selvaganesang Date: 2016-07-28T21:27:27Z [TRAFODION-2129] Trafodion to avoid use of deprecated HBase APIs/Classes References to the deprecated classes HConnection, HConnectionManager and HBaseAdmin are reworked to use Connection, ConnectionFactory and Admin classes respectively. A connection object is created and it is passed around to ensure that the same connection objects within the same process. Admin object is created and closed after its use immediately. > Trafodion to avoid use of deprecated HBase APIs/Classes > --- > > Key: TRAFODION-2129 > URL: https://issues.apache.org/jira/browse/TRAFODION-2129 > Project: Apache Trafodion > Issue Type: Improvement > Components: dtm, sql-exe >Affects Versions: 2.0-incubating >Reporter: Selvaganesan Govindarajan >Assignee: Selvaganesan Govindarajan > Original Estimate: 168h > Remaining Estimate: 168h > > Avoid the use of HConnection, HConnectionManager and, HBaseAdmin in Trafodion > and use Connection, ConnectionFactory and Admin respectively. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (TRAFODION-2135) Protobuf 2.5 needs to be added to build tool dependencies
Steve Varnau created TRAFODION-2135: --- Summary: Protobuf 2.5 needs to be added to build tool dependencies Key: TRAFODION-2135 URL: https://issues.apache.org/jira/browse/TRAFODION-2135 Project: Apache Trafodion Issue Type: Bug Reporter: Steve Varnau Assignee: Steve Varnau Protobuf is used to create code for hbase-trx that is currently checked-in instead of generated during the build process. This process is becoming complicated and error-prone as we support more and more distros/versions of HBase. This needs to change to be added to regular build process. But that adds a new dependency for building. Need to script and document this build tool. We require 2.5.0, which comes as the current version on RH/Centos 7, but there is older version on the RH/Centos 6 distro. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (TRAFODION-1868) Compatibility with gcc 4.8
[ https://issues.apache.org/jira/browse/TRAFODION-1868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming updated TRAFODION-1868: Assignee: Arvind Narain (was: liu ming) > Compatibility with gcc 4.8 > -- > > Key: TRAFODION-1868 > URL: https://issues.apache.org/jira/browse/TRAFODION-1868 > Project: Apache Trafodion > Issue Type: Bug >Reporter: Steve Varnau >Assignee: Arvind Narain >Priority: Minor > > Current code will not compile with gcc 4.8. That is the default version on > RH/CentOS 7. This is needed to move to a development environment on CentOS 7. > There is a 4.4 version of gcc available on 7. The RPM package is > compat-gcc-44, I have not tried building on 7.x with older compiler, but will > likely work. > This is not urgent at this time, but we should move toward enabling a newer > dev environment. But this needs to be coordinated with with versions of OS > are supported for runtime use of trafodion. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-2134) Change the overflow_mode to 'DISK' by default
[ https://issues.apache.org/jira/browse/TRAFODION-2134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15398697#comment-15398697 ] ASF GitHub Bot commented on TRAFODION-2134: --- GitHub user selvaganesang opened a pull request: https://github.com/apache/incubator-trafodion/pull/628 [TRAFODION-2134] Change the overflow_mode to 'DISK' by default You can merge this pull request into a Git repository by running: $ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-2134 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/628.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 #628 commit 675017b05dcdeb3e6f3c6768517ffb2091fb482d Author: selvaganesang Date: 2016-07-29T04:36:30Z [TRAFODION-2134] Change the overflow_mode to 'DISK' by default > Change the overflow_mode to 'DISK' by default > - > > Key: TRAFODION-2134 > URL: https://issues.apache.org/jira/browse/TRAFODION-2134 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-exe >Affects Versions: 2.1-incubating >Reporter: Selvaganesan Govindarajan >Assignee: Selvaganesan Govindarajan > Fix For: 2.1-incubating > > Original Estimate: 24h > Remaining Estimate: 24h > > In queries involving Block Memory Operators (BMOs), Trafodion can overflow > the data from the data flow into scratch files. These scratch files are > currently being memory mapped which puts pressure on the memory usage on the > node when there is large amount of overflow. The default needs to be changed > to DISK -- This message was sent by Atlassian JIRA (v6.3.4#6332)