fix bug 1343661(cleanup HBASE partitioning), bug 1347819 and bug 1343566 1343661: please refer to sql/sqlcomp/DefaultConstConstants.h for the definition of CQD HBASE_PARTITIONING. 1347819: the change is in ExExeUtilLoad.cpp to disable HASH2 for fast load. 1343566: method NADefaults::getTotalNumOfESPsInCluster() now returns the correct value if CQD PARALLEL_NUM_ESPS is set to an integer value. Rework 1 to address Dave's review comments. Rework 2 to address Khaled's review comments as follows. A Boolean flag (isTrafLoadPrep_) is added to class BinWA to better control the type of partitioning functions needed for the traf preparation step. When we are binding all nodes, the flag is set to TRUE which instructs createNAFileSet() not to create hash2. Rework 3 to address Hans's review comments. If force to have hash2 and the partitioning function in the cached table is range, do not return the cached object. Rework 4 to address seabase/TEST015 core, which is reported in bug 1349990. Bug 1349990 is fixed in this rework.
Modify the semantics of CQD MAX_ESPS_PER_CPU_PER_OP to become a factor in computing the max #ESPs per core. The #esps per node = CQD * cores per, node and the total number of ESPs per cluster is #esps per node * #nodes. The CQD now takes a real number.
The work consolidates all references to the CQD to three new methods NADefaults::getNumOfESPsPerNode(), NADefaults::getNumOfESPsPerNodeInFloat() and NADefaults::getTotalNumOfESPsInCluster().