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.