[
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 <[email protected]>
Date: 2017-01-26T22:01:05Z
Changes to remove restriction to use vsbb for upserts on base table.
commit 22a46a385b501f0688502af49834af7ec24803c2
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-01-26T22:01:56Z
Merge remote branch 'origin/master' into vsbb_upsert
commit 7760c9f4bc625e2c1e77fdc6b0b23fba867d1191
Author: Sandhya Sundaresan <[email protected]>
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 <[email protected]>
Date: 2017-02-03T01:32:35Z
Merge remote branch 'origin/master' into vsbb_upsert
commit 437ae6d0ee3a196722bae294206a6b6b7a866635
Author: Sandhya Sundaresan <[email protected]>
Date: 2017-02-06T21:31:14Z
Separate the transformation cases to be merge or the new eff tree.
commit d9d5d88facb7bdcd44cba8fbc5e935782668fb53
Author: Sandhya Sundaresan <[email protected]>
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)
