You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/02/07 21:27:41 UTC
[jira] [Commented] (TRAFODION-1562) Changes in query tree when the
upsert command is transformed into merge
[ https://issues.apache.org/jira/browse/TRAFODION-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15856824#comment-15856824 ]
ASF GitHub Bot commented on TRAFODION-1562:
-------------------------------------------
GitHub user sandhyasun opened a pull request:
https://github.com/apache/incubator-trafodion/pull/946
TRAFODION-1562 Enable Vsbb upsert for base table nodes when more than row
This is part of a performance enhancment for the upsert with index feature. The CQD tRAF_UPSERT_TO_EFF_TREE is also being turned on by default with this PR. Had to make a few tweaks to the merge transformation so both the old and new ways are intact. Enhanced the VSBB executor operator to project rows. This is enabled in the generator only when needed - i.e when the operator needs to freturn rows for other operators to consume.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/incubator-trafodion vsbb_upsert
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/946.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 #946
----
commit d92de579a7ee11ba46ce1990bd784f0e85b15c69
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-01-26T22:01:05Z
Changes to remove restriction to use vsbb for upserts on base table.
commit 22a46a385b501f0688502af49834af7ec24803c2
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-01-26T22:01:56Z
Merge remote branch 'origin/master' into vsbb_upsert
commit 7760c9f4bc625e2c1e77fdc6b0b23fba867d1191
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-02-03T01:28:32Z
Turning on CQD TRAF_UPSERT_TO_EFF_TREE 'ON' by default. Fixed a couple of issues during inlining.1. RI constraints had to be handled .2. The Sequence node had to be modified to avoid an unneeded copyTree that was causing problems with subqueries. 3. A new flag introduced to identify that we are int he midst of this transformation.
Modified TEST015 to print out the details for the new transformation.
commit 6b5799b1f232f61060b226ff8477469e8799c28f
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-02-03T01:32:35Z
Merge remote branch 'origin/master' into vsbb_upsert
commit 437ae6d0ee3a196722bae294206a6b6b7a866635
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-02-06T21:31:14Z
Separate the transformation cases to be merge or the new eff tree.
commit d9d5d88facb7bdcd44cba8fbc5e935782668fb53
Author: Sandhya Sundaresan <sa...@apache.org>
Date: 2017-02-06T21:32:30Z
Merge remote branch 'origin/master' into vsbb_upsert
----
> Changes in query tree when the upsert command is transformed into merge
> -----------------------------------------------------------------------
>
> Key: TRAFODION-1562
> URL: https://issues.apache.org/jira/browse/TRAFODION-1562
> Project: Apache Trafodion
> Issue Type: Sub-task
> Components: sql-cmp
> Reporter: Selvaganesan Govindarajan
> Assignee: Sandhya Sundaresan
> Attachments: BatchUpsertTransformation.pdf
>
>
> to improve the performance as explained in the main JIRA
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)