You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/03/04 00:31:11 UTC
[1/2] incubator-trafodion git commit: [TRAFODION-1867] Allow parallel
plans for non-partitioned tables in UPD STATS
Repository: incubator-trafodion
Updated Branches:
refs/heads/master a717a3e63 -> e24ea17da
[TRAFODION-1867] Allow parallel plans for non-partitioned tables in UPD STATS
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/07bf4163
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/07bf4163
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/07bf4163
Branch: refs/heads/master
Commit: 07bf4163bf3c5b8bc863332886464e69f44cea6b
Parents: 39d3a0c
Author: Dave Birdsall <db...@apache.org>
Authored: Wed Mar 2 22:52:19 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Wed Mar 2 22:52:19 2016 +0000
----------------------------------------------------------------------
core/sql/ustat/hs_globals.cpp | 20 --------------------
1 file changed, 20 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/07bf4163/core/sql/ustat/hs_globals.cpp
----------------------------------------------------------------------
diff --git a/core/sql/ustat/hs_globals.cpp b/core/sql/ustat/hs_globals.cpp
index 01a65d6..ff984e1 100644
--- a/core/sql/ustat/hs_globals.cpp
+++ b/core/sql/ustat/hs_globals.cpp
@@ -5568,16 +5568,6 @@ Lng32 HSGlobalsClass::CollectStatistics()
//The result will always be a VARCHAR(len) CHARACTER SET UCS2
//In most cases, this will reduce the number of fetches.
- //10-040618-7112: temporary workaround for compiler issue
- //make sure no parallel plans get generated for single partitioned tables
- //The sample table for SQLMP tables are always single partition. Whereas for
- //SQLMX, the table may be partitioned based on the HIST_SCRATCH_VOL cqd.
- if ((sampleTableUsed && tableFormat == SQLMP) ||
- (NOT sampleTableUsed && objDef->getNumPartitions() == 1))
- {
- HSFuncExecQuery("CONTROL QUERY DEFAULT ATTEMPT_ESP_PARALLELISM 'OFF'");
- }
-
if (CmpCommon::getDefault(USTAT_ATTEMPT_ESP_PARALLELISM) == DF_OFF)
HSFuncExecQuery("CONTROL QUERY DEFAULT ATTEMPT_ESP_PARALLELISM 'OFF'");
@@ -5736,16 +5726,6 @@ Lng32 HSGlobalsClass::CollectStatistics()
LM->StopTimer();
}
- //10-040618-7112: temporary workaround for compiler issue
- //make sure no parallel plans get generated for single partitioned tables
- //The sample table for SQLMP tables are always single partition. Whereas for
- //SQLMX, the table may be partitioned based on the HIST_SCRATCH_VOL cqd.
- if ((sampleTableUsed && tableFormat == SQLMP) ||
- (NOT sampleTableUsed && objDef->getNumPartitions() == 1))
- {
- HSFuncExecQuery("CONTROL QUERY DEFAULT ATTEMPT_ESP_PARALLELISM RESET");
- }
-
if (CmpCommon::getDefault(USTAT_ATTEMPT_ESP_PARALLELISM) == DF_OFF)
HSFuncExecQuery("CONTROL QUERY DEFAULT ATTEMPT_ESP_PARALLELISM RESET");
[2/2] incubator-trafodion git commit: Merge [TRAFODION-1867] PR 357
Fix serial plan issue in UPD STATS
Posted by db...@apache.org.
Merge [TRAFODION-1867] PR 357 Fix serial plan issue in UPD STATS
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/e24ea17d
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/e24ea17d
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/e24ea17d
Branch: refs/heads/master
Commit: e24ea17da12d6e470d677e442e26cef360b95cf1
Parents: a717a3e 07bf416
Author: Dave Birdsall <db...@apache.org>
Authored: Thu Mar 3 23:30:20 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Thu Mar 3 23:30:20 2016 +0000
----------------------------------------------------------------------
core/sql/ustat/hs_globals.cpp | 20 --------------------
1 file changed, 20 deletions(-)
----------------------------------------------------------------------