trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [3/4] incubator-trafodion git commit: Implement TRAFODION-1420 Use ClientSmallScanner for small scans to improve perdormance Hbase implements an optimization for small scan (defined as scanning less than a data block ie 64Kb) resulting in 3X performance
Date Thu, 28 Jan 2016 00:17:50 GMT
Implement TRAFODION-1420 Use ClientSmallScanner for small scans to improve perdormance
Hbase implements an optimization for small scan (defined as scanning less than a data block ie 64Kb) resulting in 3X performance improvement. The underlying trick is about cutting down RPC calls from 3 (OpenScan/Next/Close) to 1, and use pread stateless instead of seek/read state-full and locking method to read data. This JIRA is about improving the compiler who can be aware if a scan will be acting on single data block (small) or not, and pass this data to executor so that it can use the right parameter for scan. (scan.setSmall(boolean)).
reference:
https://issues.apache.org/jira/browse/HBASE-9488
https://issues.apache.org/jira/browse/HBASE-7266


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/49a06f8b
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/49a06f8b
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/49a06f8b

Branch: refs/heads/master
Commit: 49a06f8be5f2c35b4f6ea20fd4220143addddc7a
Parents: ff4b7dd
Author: Eric Owhadi <eric.owhadi@esgyn.com>
Authored: Mon Jan 25 17:40:50 2016 +0000
Committer: Eric Owhadi <eric.owhadi@esgyn.com>
Committed: Mon Jan 25 17:40:50 2016 +0000

----------------------------------------------------------------------
 core/sql/comexe/ComTdbHbaseAccess.cpp           |  16 +-
 core/sql/comexe/ComTdbHbaseAccess.h             |  10 +-
 core/sql/executor/ExHbaseIUD.cpp                |   2 +
 core/sql/executor/ExHbaseSelect.cpp             |   4 +
 core/sql/executor/HBaseClient_JNI.cpp           |   7 +-
 core/sql/executor/HBaseClient_JNI.h             |   2 +-
 core/sql/exp/ExpHbaseInterface.cpp              |  11 +-
 core/sql/exp/ExpHbaseInterface.h                |   6 +-
 core/sql/generator/GenExplain.cpp               |   5 +
 core/sql/generator/GenRelScan.cpp               |  11 +
 core/sql/generator/Generator.cpp                |  12 +
 core/sql/generator/Generator.h                  |   4 +-
 core/sql/regress/executor/DIFF013.KNOWN         |   2 +-
 core/sql/regress/executor/EXPECTED013.SB        |  29 +-
 core/sql/regress/executor/EXPECTED131           | 453 ++++++++++++++++
 core/sql/regress/executor/EXPECTED140           |  48 +-
 core/sql/regress/executor/FILTER131             |  31 ++
 core/sql/regress/executor/TEST131               |  96 ++++
 core/sql/regress/fullstack2/EXPECTED062         |  41 +-
 core/sql/regress/fullstack2/EXPECTED062.RELEASE |  33 +-
 core/sql/regress/seabase/EXPECTED010            | 532 ++++++++++++-------
 core/sql/regress/seabase/EXPECTED011            |  20 +-
 core/sql/regress/seabase/EXPECTED016            |  35 +-
 core/sql/regress/tools/runregr_executor.ksh     |   2 +-
 core/sql/regress/tools/sbdefs                   |   1 +
 core/sql/sqlcomp/DefaultConstants.h             |   2 +
 core/sql/sqlcomp/nadefaults.cpp                 |   2 +
 .../java/org/trafodion/sql/HTableClient.java    |   3 +-
 28 files changed, 1116 insertions(+), 304 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/comexe/ComTdbHbaseAccess.cpp
----------------------------------------------------------------------
diff --git a/core/sql/comexe/ComTdbHbaseAccess.cpp b/core/sql/comexe/ComTdbHbaseAccess.cpp
index 050018a..8276553 100644
--- a/core/sql/comexe/ComTdbHbaseAccess.cpp
+++ b/core/sql/comexe/ComTdbHbaseAccess.cpp
@@ -638,14 +638,12 @@ static void showColNames(Queue * listOfColNames, Space * space)
       char colFam[100];
       while (currPtr[currPos] != ':')
 	{
-	  colFam[jj] = currPtr[currPos];
 	  currPos++;
 	  jj++;
 	}
-      colFam[jj] = ':';
       jj++;
       currPos++;
-      colFam[jj] = 0;
+      snprintf(colFam,sizeof(colFam),"%.*s",jj,currPtr+sizeof(short));
       colNameLen -= jj;
       
       NABoolean withAt = FALSE;
@@ -696,19 +694,9 @@ static void showStrColNames(Queue * listOfColNames, Space * space,
 	}
       else
 	{
-	  Lng32 currPos = 0;
 	  short colNameLen = *(short*)currPtr;
-	  currPos += sizeof(short);
 	  char colName[500];
-	  
-	  for (Lng32 i = 0; i < colNameLen; i++)
-	    {
-	      colName[i] = currPtr[currPos];
-	      currPos++;
-	    }
-	  
-	  colName[colNameLen] = 0;
-	  
+	  snprintf(colName,sizeof(colName),"%.*s",colNameLen,currPtr+sizeof(short));
 	  colNamePtr = colName;
 	}
 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/comexe/ComTdbHbaseAccess.h
----------------------------------------------------------------------
diff --git a/core/sql/comexe/ComTdbHbaseAccess.h b/core/sql/comexe/ComTdbHbaseAccess.h
index 1a19dd9..c3b11f6 100644
--- a/core/sql/comexe/ComTdbHbaseAccess.h
+++ b/core/sql/comexe/ComTdbHbaseAccess.h
@@ -265,11 +265,19 @@ public:
     NABoolean useMinMdamProbeSize() 
     { return (flags_ & USE_MIN_MDAM_PROBE_SIZE) != 0; };
 
+    void setUseSmallScanner(NABoolean v)
+    {(v ? flags_ |= USE_SMALL_SCANNER :
+      flags_ &= ~USE_SMALL_SCANNER); };
+    NABoolean useSmallScanner()
+    { return (flags_ & USE_SMALL_SCANNER) != 0; };
+
+
   private:
     enum
     {
       CACHE_BLOCKS               = 0x0001,
-      USE_MIN_MDAM_PROBE_SIZE    = 0x0002
+      USE_MIN_MDAM_PROBE_SIZE    = 0x0002,
+      USE_SMALL_SCANNER          = 0x0004
     };
     
     UInt32 flags_;

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/executor/ExHbaseIUD.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExHbaseIUD.cpp b/core/sql/executor/ExHbaseIUD.cpp
index b668cb9..d71eb8c 100644
--- a/core/sql/executor/ExHbaseIUD.cpp
+++ b/core/sql/executor/ExHbaseIUD.cpp
@@ -2790,6 +2790,7 @@ ExWorkProcRetcode ExHbaseUMDtrafSubsetTaskTcb::work(short &rc)
 					   tcb_->columns_, -1,
 					   tcb_->hbaseAccessTdb().readUncommittedScan(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->cacheBlocks(),
+					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->useSmallScanner(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->numCacheRows(),
 					   FALSE, NULL, NULL, NULL);
 	    if (tcb_->setupError(retcode, "ExpHbaseInterface::scanOpen"))
@@ -3204,6 +3205,7 @@ ExWorkProcRetcode ExHbaseUMDnativeSubsetTaskTcb::work(short &rc)
 					   columns, -1,
 					   tcb_->hbaseAccessTdb().readUncommittedScan(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->cacheBlocks(),
+					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->useSmallScanner(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->numCacheRows(),
 					   FALSE, NULL, NULL, NULL);
 	    if (tcb_->setupError(retcode, "ExpHbaseInterface::scanOpen"))

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/executor/ExHbaseSelect.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExHbaseSelect.cpp b/core/sql/executor/ExHbaseSelect.cpp
index 68f66d0..5aabd9a 100644
--- a/core/sql/executor/ExHbaseSelect.cpp
+++ b/core/sql/executor/ExHbaseSelect.cpp
@@ -81,6 +81,7 @@ ExWorkProcRetcode ExHbaseScanTaskTcb::work(short &rc)
 					   tcb_->columns_, -1,
 					   tcb_->hbaseAccessTdb().readUncommittedScan(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->cacheBlocks(),
+					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->useSmallScanner(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->numCacheRows(),
 					   FALSE, 
 					   (tcb_->hbaseFilterColumns_.entries() > 0 ?
@@ -265,6 +266,7 @@ ExWorkProcRetcode ExHbaseScanRowwiseTaskTcb::work(short &rc)
 					   tcb_->columns_, -1,
 					   tcb_->hbaseAccessTdb().readUncommittedScan(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->cacheBlocks(),
+					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->useSmallScanner(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->numCacheRows(),
 					   FALSE, 
 					   (tcb_->hbaseFilterColumns_.entries() > 0 ?
@@ -471,6 +473,7 @@ ExWorkProcRetcode ExHbaseScanSQTaskTcb::work(short &rc)
 					   tcb_->columns_, -1,
 					   tcb_->hbaseAccessTdb().readUncommittedScan(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->cacheBlocks(),
+					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->useSmallScanner(),
 					   tcb_->hbaseAccessTdb().getHbasePerfAttributes()->numCacheRows(),
                                            TRUE,
 					   (tcb_->hbaseFilterColumns_.entries() > 0 ?
@@ -645,6 +648,7 @@ Lng32 ExHbaseScanSQTaskTcb::getProbeResult(char* &keyData)
 				 tcb_->columns_, -1,
 				 tcb_->hbaseAccessTdb().readUncommittedScan(),
 				 tcb_->hbaseAccessTdb().getHbasePerfAttributes()->cacheBlocks(),
+				 tcb_->hbaseAccessTdb().getHbasePerfAttributes()->useSmallScanner(),
 				 probeSize,
 				 TRUE, NULL, NULL, NULL);
   if (tcb_->setupError(retcode, "ExpHbaseInterface::scanOpen"))

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/executor/HBaseClient_JNI.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/HBaseClient_JNI.cpp b/core/sql/executor/HBaseClient_JNI.cpp
index a2572e4..3ff3e1f 100644
--- a/core/sql/executor/HBaseClient_JNI.cpp
+++ b/core/sql/executor/HBaseClient_JNI.cpp
@@ -3623,7 +3623,7 @@ HTC_RetCode HTableClient_JNI::init()
     JavaMethods_[JM_GET_ERROR  ].jm_name      = "getLastError";
     JavaMethods_[JM_GET_ERROR  ].jm_signature = "()Ljava/lang/String;";
     JavaMethods_[JM_SCAN_OPEN  ].jm_name      = "startScan";
-    JavaMethods_[JM_SCAN_OPEN  ].jm_signature = "(J[B[B[Ljava/lang/Object;JZI[Ljava/lang/Object;[Ljava/lang/Object;[Ljava/lang/Object;FZZILjava/lang/String;Ljava/lang/String;II)Z";
+    JavaMethods_[JM_SCAN_OPEN  ].jm_signature = "(J[B[B[Ljava/lang/Object;JZZI[Ljava/lang/Object;[Ljava/lang/Object;[Ljava/lang/Object;FZZILjava/lang/String;Ljava/lang/String;II)Z";
     JavaMethods_[JM_DELETE     ].jm_name      = "deleteRow";
     JavaMethods_[JM_DELETE     ].jm_signature = "(J[B[Ljava/lang/Object;JZ)Z";
     JavaMethods_[JM_COPROC_AGGR     ].jm_name      = "coProcAggr";
@@ -3667,7 +3667,7 @@ NAString HTableClient_JNI::getLastJavaError()
 //////////////////////////////////////////////////////////////////////////////
 HTC_RetCode HTableClient_JNI::startScan(Int64 transID, const Text& startRowID, 
    const Text& stopRowID, const LIST(HbaseStr) & cols, Int64 timestamp, 
-   bool cacheBlocks, Lng32 numCacheRows, NABoolean preFetch,
+   bool cacheBlocks, bool smallScanner, Lng32 numCacheRows, NABoolean preFetch,
 					const LIST(NAString) *inColNamesToFilter, 
 					const LIST(NAString) *inCompareOpList,
 					const LIST(NAString) *inColValuesToCompare,
@@ -3728,6 +3728,7 @@ HTC_RetCode HTableClient_JNI::startScan(Int64 transID, const Text& startRowID,
   jlong j_ts = timestamp;
 
   jboolean j_cb = cacheBlocks;
+  jboolean j_smallScanner = smallScanner;
   jboolean j_preFetch = preFetch;
   jint j_ncr = numCacheRows;
   numReqRows_ = numCacheRows;
@@ -3823,7 +3824,7 @@ HTC_RetCode HTableClient_JNI::startScan(Int64 transID, const Text& startRowID,
   jboolean jresult = jenv_->CallBooleanMethod(
                                               javaObj_, 
                                               JavaMethods_[JM_SCAN_OPEN].methodID, 
-                                              j_tid, jba_startRowID, jba_stopRowID, j_cols, j_ts, j_cb, j_ncr,
+                                              j_tid, jba_startRowID, jba_stopRowID, j_cols, j_ts, j_cb, j_smallScanner, j_ncr,
                                               j_colnamestofilter, j_compareoplist, j_colvaluestocompare, 
                                               j_smplPct, j_preFetch, j_useSnapshotScan,
                                               j_snapTimeout, js_snapName, js_tmp_loc, j_espNum,

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/executor/HBaseClient_JNI.h
----------------------------------------------------------------------
diff --git a/core/sql/executor/HBaseClient_JNI.h b/core/sql/executor/HBaseClient_JNI.h
index b7edd01..d015ec2 100644
--- a/core/sql/executor/HBaseClient_JNI.h
+++ b/core/sql/executor/HBaseClient_JNI.h
@@ -245,7 +245,7 @@ public:
   
   HTC_RetCode init();
   
-  HTC_RetCode startScan(Int64 transID, const Text& startRowID, const Text& stopRowID, const LIST(HbaseStr) & cols, Int64 timestamp, bool cacheBlocks, Lng32 numCacheRows,
+  HTC_RetCode startScan(Int64 transID, const Text& startRowID, const Text& stopRowID, const LIST(HbaseStr) & cols, Int64 timestamp, bool cacheBlocks, bool smallScanner, Lng32 numCacheRows,
                         NABoolean preFetch,
 			const LIST(NAString) *inColNamesToFilter, 
 			const LIST(NAString) *inCompareOpList,

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/exp/ExpHbaseInterface.cpp
----------------------------------------------------------------------
diff --git a/core/sql/exp/ExpHbaseInterface.cpp b/core/sql/exp/ExpHbaseInterface.cpp
index 9bea32b..b58383c 100644
--- a/core/sql/exp/ExpHbaseInterface.cpp
+++ b/core/sql/exp/ExpHbaseInterface.cpp
@@ -124,7 +124,7 @@ Int32 ExpHbaseInterface_JNI::deleteColumns(
   Int64 transID = getTransactionIDFromContext();
 
   int numReqRows = 100;
-  retcode = htc_->startScan(transID, "", "", columns, -1, FALSE, numReqRows, FALSE, 
+  retcode = htc_->startScan(transID, "", "", columns, -1, FALSE, FALSE, numReqRows, FALSE,
        NULL, NULL, NULL, NULL);
   if (retcode != HTC_OK)
     return retcode;
@@ -206,7 +206,7 @@ Lng32  ExpHbaseInterface::fetchAllRows(
         break;
   }
 
-  retcode = scanOpen(tblName, "", "", columns, -1, FALSE, FALSE, 100, TRUE, NULL, 
+  retcode = scanOpen(tblName, "", "", columns, -1, FALSE, FALSE, FALSE, 100, TRUE, NULL,
        NULL, NULL, NULL);
   if (retcode != HBASE_ACCESS_SUCCESS)
     return retcode;
@@ -633,6 +633,7 @@ Lng32 ExpHbaseInterface_JNI::scanOpen(
 				      const int64_t timestamp,
 				      const NABoolean noXn,
 				      const NABoolean cacheBlocks,
+				      const NABoolean smallScanner,
 				      const Lng32 numCacheRows,
                                       const NABoolean preFetch,
 				      const LIST(NAString) *inColNamesToFilter,
@@ -659,7 +660,9 @@ Lng32 ExpHbaseInterface_JNI::scanOpen(
   else
     transID = getTransactionIDFromContext();
   retCode_ = htc_->startScan(transID, startRow, stopRow, columns, timestamp, 
-                             cacheBlocks, numCacheRows, 
+                             cacheBlocks,
+                             smallScanner,
+                             numCacheRows,
                              preFetch,
                              inColNamesToFilter,
                              inCompareOpList,
@@ -1157,7 +1160,7 @@ Lng32 ExpHbaseInterface_JNI::isEmpty(
   
   LIST(HbaseStr) columns(heap_);
 
-  retcode = scanOpen(tblName, "", "", columns, -1, FALSE, FALSE, 100, TRUE, NULL, 
+  retcode = scanOpen(tblName, "", "", columns, -1, FALSE, FALSE, FALSE, 100, TRUE, NULL,
        NULL, NULL, NULL);
   if (retcode != HBASE_ACCESS_SUCCESS)
     return -HBASE_OPEN_ERROR;

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/exp/ExpHbaseInterface.h
----------------------------------------------------------------------
diff --git a/core/sql/exp/ExpHbaseInterface.h b/core/sql/exp/ExpHbaseInterface.h
index 1bf50b5..474503c 100644
--- a/core/sql/exp/ExpHbaseInterface.h
+++ b/core/sql/exp/ExpHbaseInterface.h
@@ -151,8 +151,9 @@ class ExpHbaseInterface : public NABasicObject
 			 const int64_t timestamp,
 			 const NABoolean readUncommitted,
 			 const NABoolean cacheBlocks,
+			 const NABoolean smallScanner,
 			 const Lng32 numCacheRows,
-                         const NABoolean preFetch,
+             const NABoolean preFetch,
 			 const LIST(NAString) *inColNamesToFilter, 
 			 const LIST(NAString) *inCompareOpList,
 			 const LIST(NAString) *inColValuesToCompare,
@@ -464,8 +465,9 @@ class ExpHbaseInterface_JNI : public ExpHbaseInterface
 			 const int64_t timestamp,
 			 const NABoolean readUncommitted,
 			 const NABoolean cacheBlocks,
+			 const NABoolean smallScanner,
 			 const Lng32 numCacheRows,
-                         const NABoolean preFetch,
+             const NABoolean preFetch,
 			 const LIST(NAString) *inColNamesToFilter, 
 			 const LIST(NAString) *inCompareOpList,
 			 const LIST(NAString) *inColValuesToCompare,

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/generator/GenExplain.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenExplain.cpp b/core/sql/generator/GenExplain.cpp
index 7f8c8b4..e419dca 100644
--- a/core/sql/generator/GenExplain.cpp
+++ b/core/sql/generator/GenExplain.cpp
@@ -950,6 +950,11 @@ HbaseAccess::addSpecificExplainInfo(ExplainTupleMaster *explainTuple,
     description += "OFF " ;
   }
 
+  if ((((ComTdbHbaseAccess *)tdb)->getHbasePerfAttributes()->useSmallScanner())) {
+    description += "small_scanner: " ;
+    description += "ON " ;
+  }
+
   char buf[20];
   if ( getProbes().getValue() > 0.0 ) {
     description += "probes: "; // total number of probes

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/generator/GenRelScan.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenRelScan.cpp b/core/sql/generator/GenRelScan.cpp
index a57bf8e..6b91734 100644
--- a/core/sql/generator/GenRelScan.cpp
+++ b/core/sql/generator/GenRelScan.cpp
@@ -2794,6 +2794,17 @@ short HbaseAccess::codeGen(Generator * generator)
   generator->setHBaseCacheBlocks(computedHBaseRowSizeFromMetaData,
                                  getEstRowsAccessed().getValue(),hbpa);
 
+  Lng32 hbaseBlockSize = 65536; //default HBaseValue, should not be useful as the if statement should always pass
+  if(getIndexDesc() && getIndexDesc()->getNAFileSet())
+    hbaseBlockSize = getIndexDesc()->getNAFileSet()->getBlockSize();
+
+  generator->setHBaseSmallScanner(computedHBaseRowSizeFromMetaData,
+                                getEstRowsAccessed().getValue(),
+                                hbaseBlockSize,
+                                hbpa);
+
+
+
   ComTdbHbaseAccess::HbaseAccessOptions * hbo = NULL;
   if (getHbaseAccessOptions())
     {

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/generator/Generator.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/Generator.cpp b/core/sql/generator/Generator.cpp
index 38fa134..9c8cee3 100644
--- a/core/sql/generator/Generator.cpp
+++ b/core/sql/generator/Generator.cpp
@@ -3132,3 +3132,15 @@ void Generator::setHBaseCacheBlocks(Int32 hbaseRowSize, double estRowsAccessed,
       hbpa->setCacheBlocks(TRUE);
   }
 }
+
+void Generator::setHBaseSmallScanner(Int32 hbaseRowSize, double estRowsAccessed,
+                      Lng32 hbaseBlockSize, ComTdbHbaseAccess::HbasePerfAttributes * hbpa)
+{
+  if (CmpCommon::getDefault(HBASE_SMALL_SCANNER) == DF_SYSTEM)
+  {
+    if((hbaseRowSize*estRowsAccessed)<hbaseBlockSize)
+        hbpa->setUseSmallScanner(TRUE);
+  }else if (CmpCommon::getDefault(HBASE_SMALL_SCANNER) == DF_ON)
+      hbpa->setUseSmallScanner(TRUE);
+}
+

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/generator/Generator.h
----------------------------------------------------------------------
diff --git a/core/sql/generator/Generator.h b/core/sql/generator/Generator.h
index 3706f65..a057d33 100644
--- a/core/sql/generator/Generator.h
+++ b/core/sql/generator/Generator.h
@@ -1639,7 +1639,9 @@ public:
                             Float32 samplePercent = 0.0);
   void setHBaseCacheBlocks(Int32 hbaseRowSize, double rowsAccessed, 
                            ComTdbHbaseAccess::HbasePerfAttributes * hbpa);
-  
+  void setHBaseSmallScanner(Int32 hbaseRowSize, double rowsAccessed,
+                          Int32 hbaseBlockSize, ComTdbHbaseAccess::HbasePerfAttributes * hbpa);
+
 
   NASet<Int64> &objectUids() { return objectUids_; }
 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/executor/DIFF013.KNOWN
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/DIFF013.KNOWN b/core/sql/regress/executor/DIFF013.KNOWN
index 02796b0..16c6e8f 100755
--- a/core/sql/regress/executor/DIFF013.KNOWN
+++ b/core/sql/regress/executor/DIFF013.KNOWN
@@ -1,4 +1,4 @@
-537a538,541
+538a539,542
 > >>--explain select * from t013t1;
 > >>--explain options 'f' select * from t013t1;
 > >>--explain insert into t013t1 values (1);

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/executor/EXPECTED013.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED013.SB b/core/sql/regress/executor/EXPECTED013.SB
index 41483a6..e4faaec 100644
--- a/core/sql/regress/executor/EXPECTED013.SB
+++ b/core/sql/regress/executor/EXPECTED013.SB
@@ -21,7 +21,7 @@
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Fri Dec 12 13:13:55 2014
+-- Definition current  Sat Jan 23 02:44:37 2016
 
   (
     A                                INT DEFAULT NULL
@@ -49,7 +49,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion volatile table T013T1
--- Definition current  Fri Dec 12 13:14:07 2014
+-- Definition current  Sat Jan 23 02:44:54 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -111,7 +111,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Fri Dec 12 13:14:47 2014
+-- Definition current  Sat Jan 23 02:45:57 2016
 
   (
     A                                INT DEFAULT NULL
@@ -136,7 +136,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion volatile table T013T1
--- Definition current  Fri Dec 12 13:14:57 2014
+-- Definition current  Sat Jan 23 02:46:10 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -175,7 +175,7 @@ A            B            C
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Fri Dec 12 13:15:08 2014
+-- Definition current  Sat Jan 23 02:46:25 2016
 
   (
     A                                INT DEFAULT NULL
@@ -197,7 +197,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion volatile table T013T1
--- Definition current  Fri Dec 12 13:15:10 2014
+-- Definition current  Sat Jan 23 02:46:32 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -433,7 +433,8 @@ CONTROL QUERY DEFAULT
   MODE_SEABASE                  	ON
   SEABASE_VOLATILE_TABLES       	ON
   HBASE_SERIALIZATION           	ON
-  HBASE_FILTER_PREDS            	ON
+  HBASE_SMALL_SCANNER           	SYSTEM
+  HBASE_FILTER_PREDS            	2
   TRAF_INDEX_CREATE_OPT         	ON
   HBASE_ASYNC_DROP_TABLE        	OFF
   POS                           	OFF
@@ -447,7 +448,7 @@ CONTROL QUERY DEFAULT
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Fri Dec 12 13:15:54 2014
+-- Definition current  Sat Jan 23 02:47:38 2016
 
   (
     A                                INT DEFAULT NULL
@@ -467,7 +468,7 @@ CONTROL QUERY DEFAULT
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Fri Dec 12 13:15:59 2014
+-- Definition current  Sat Jan 23 02:47:43 2016
 
   (
     A                                INT DEFAULT NULL
@@ -558,7 +559,7 @@ control query shape nested_join(anything,anything);
 >>invoke t013t3;
 
 -- Definition of Trafodion table TRAFODION.T013SCH1.T013T3
--- Definition current  Fri Dec 12 13:16:42 2014
+-- Definition current  Sat Jan 23 02:48:28 2016
 
   (
     A                                INT DEFAULT NULL
@@ -575,7 +576,7 @@ control query shape nested_join(anything,anything);
 >>invoke t013t3;
 
 -- Definition of Trafodion volatile table T013T3
--- Definition current  Fri Dec 12 13:16:44 2014
+-- Definition current  Sat Jan 23 02:48:35 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -590,7 +591,7 @@ control query shape nested_join(anything,anything);
 >>invoke t013t3;
 
 -- Definition of Trafodion table TRAFODION.T013SCH1.T013T3
--- Definition current  Fri Dec 12 13:16:51 2014
+-- Definition current  Sat Jan 23 02:48:47 2016
 
   (
     A                                INT DEFAULT NULL
@@ -655,7 +656,7 @@ CREATE VOLATILE TABLE T013T3
 >>invoke t013t3;
 
 -- Definition of Trafodion table TRAFODION.T013SCH1.T013T3
--- Definition current  Fri Dec 12 13:17:19 2014
+-- Definition current  Sat Jan 23 02:49:31 2016
 
   (
     A                                INT DEFAULT NULL
@@ -1276,7 +1277,7 @@ CREATE VOLATILE TABLE T013T1
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Fri Dec 12 13:21:07 2014
+-- Definition current  Sat Jan 23 02:55:57 2016
 
   (
     A                                INT DEFAULT NULL

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/executor/EXPECTED131
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED131 b/core/sql/regress/executor/EXPECTED131
new file mode 100644
index 0000000..63f5859
--- /dev/null
+++ b/core/sql/regress/executor/EXPECTED131
@@ -0,0 +1,453 @@
+>>obey TEST131(setup);
+>>create table t131helper (a int not null, primary key(a));
+
+--- SQL operation complete.
+>>insert into t131helper values(1);
+
+--- 1 row(s) inserted.
+>>create table t1311k (uniq int not null,
++>					c1000 int,
++>					str1 varchar(4000),
++>					primary key (uniq));
+
+--- SQL operation complete.
+>>insert into t1311k
++>  select (100*x100)+(10*x10)+x1,
++>  		 (100*x100)+(10*x10)+x1,
++>  		 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
++>  from t131helper
++>  		transpose 0,1,2,3,4,5,6,7,8,9 as x100
++>  		transpose 0,1,2,3,4,5,6,7,8,9 as x10
++>  		transpose 0,1,2,3,4,5,6,7,8,9 as x1;
+
+--- 1000 row(s) inserted.
+>>
+>>update statistics for table t1311k on every column sample 10 rows;
+
+--- SQL operation complete.
+>>
+>>--t1311kbis has twice the block size as t1311k that has default hbase block size of 64K  				 					      
+>>create table t1311kbis (uniq int not null,
++>					c1000 int,
++>					str1 varchar (4000),
++>					primary key (uniq))
++>					HBASE_OPTIONS (BLOCKSIZE='131072');
+
+--- SQL operation complete.
+>>insert into t1311kbis
++>  select (100*x100)+(10*x10)+x1,
++>  		 (100*x100)+(10*x10)+x1,
++>  		 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
++>  from t131helper
++>  		transpose 0,1,2,3,4,5,6,7,8,9 as x100
++>  		transpose 0,1,2,3,4,5,6,7,8,9 as x10
++>  		transpose 0,1,2,3,4,5,6,7,8,9 as x1;
+
+--- 1000 row(s) inserted.
+>>
+>>update statistics for table t1311kbis on every column sample 10 rows;
+
+--- SQL operation complete.
+>>
+>>--reload new session to make sure we are not using cached histogram
+>>sh sh runmxci.ksh -i "TEST131(dml)";
+>>-- need set CQD since invoking this section using a new sh session to force statistic to be taken into account
+>>-- suspect this is because histogram is cached per session and we are starting a new session, reloading Histogram...
+>>cqd hbase_small_scanner 'SYSTEM';
+
+--- SQL operation complete.
+>>-- should have small scanner on and endKey populated (JIRA 1446)
+>>explain select * from t1311k where uniq >2 and uniq <5;
+
+------------------------------------------------------------------ PLAN SUMMARY
+MODULE_NAME .............. DYNAMICALLY COMPILED
+STATEMENT_NAME ........... NOT NAMED
+PLAN_ID .................. 212320281474319626
+ROWS_OUT ................. 3
+EST_TOTAL_COST ........... 0.01
+STATEMENT ................ select * from t1311k where uniq >2 and uniq <5;
+
+
+------------------------------------------------------------------ NODE LISTING
+ROOT ======================================  SEQ_NO 2        ONLY CHILD 1
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 3
+EST_OPER_COST ............ 0
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est ........... 3
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  statement_index ........ 0
+  affinity_value ......... 0
+  max_max_cardinality .... 3
+  total_overflow_size .... 0.00 KB
+  xn_access_mode ......... read_only
+  xn_autoabort_interval    0
+  auto_query_retry ....... enabled
+  plan_version ....... 2,600
+  embedded_arkcmp ........ used
+  IS_SQLCI ............... ON
+  LDAP_USERNAME
+  HBASE_SMALL_SCANNER .... SYSTEM
+  GENERATE_EXPLAIN ....... ON
+  ObjectUIDs ............. 2727580673292039142
+  select_list ............ TRAFODION.SCH.T1311K.UNIQ,
+                             TRAFODION.SCH.T1311K.C1000,
+                             TRAFODION.SCH.T1311K.STR1
+
+
+TRAFODION_SCAN ============================  SEQ_NO 1        NO CHILDREN
+TABLE_NAME ............... T1311K
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 3
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est ........... 3
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  scan_type .............. subset scan of table TRAFODION.SCH.T1311K
+  object_type ............ Trafodion
+  columns ................ all
+  begin_keys(excl) ....... 2
+  end_keys(excl) ......... 5
+  cache_size ........... 100
+  small_scanner .......... ON
+  probes ................. 1
+  rows_accessed .......... 3
+  column_retrieved ....... #1:1,#1:2,#1:3
+  key_columns ............ UNIQ
+  executor_predicates .... (UNIQ > 2) and (UNIQ < 5)
+
+--- SQL operation complete.
+>>explain select * from t1311k where uniq >2 and uniq <99;
+
+------------------------------------------------------------------ PLAN SUMMARY
+MODULE_NAME .............. DYNAMICALLY COMPILED
+STATEMENT_NAME ........... NOT NAMED
+PLAN_ID .................. 212320281474426634
+ROWS_OUT ................ 97
+EST_TOTAL_COST ........... 0.01
+STATEMENT ................ select * from t1311k where uniq >2 and uniq <99;
+
+
+------------------------------------------------------------------ NODE LISTING
+ROOT ======================================  SEQ_NO 2        ONLY CHILD 1
+REQUESTS_IN .............. 1
+ROWS_OUT ................ 97
+EST_OPER_COST ............ 0
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est .......... 97
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  statement_index ........ 0
+  affinity_value ......... 0
+  max_max_cardinality ... 97
+  total_overflow_size .... 0.00 KB
+  xn_access_mode ......... read_only
+  xn_autoabort_interval    0
+  auto_query_retry ....... enabled
+  plan_version ....... 2,600
+  embedded_arkcmp ........ used
+  IS_SQLCI ............... ON
+  LDAP_USERNAME
+  HBASE_SMALL_SCANNER .... SYSTEM
+  GENERATE_EXPLAIN ....... ON
+  ObjectUIDs ............. 2727580673292039142
+  select_list ............ TRAFODION.SCH.T1311K.UNIQ,
+                             TRAFODION.SCH.T1311K.C1000,
+                             TRAFODION.SCH.T1311K.STR1
+
+
+TRAFODION_SCAN ============================  SEQ_NO 1        NO CHILDREN
+TABLE_NAME ............... T1311K
+REQUESTS_IN .............. 1
+ROWS_OUT ................ 97
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est .......... 97
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  scan_type .............. subset scan of table TRAFODION.SCH.T1311K
+  object_type ............ Trafodion
+  columns ................ all
+  begin_keys(excl) ....... 2
+  end_keys(excl) ........ 99
+  cache_size ........... 100
+  probes ................. 1
+  rows_accessed ......... 97
+  column_retrieved ....... #1:1,#1:2,#1:3
+  key_columns ............ UNIQ
+  executor_predicates .... (UNIQ > 2) and (UNIQ < 99)
+
+--- SQL operation complete.
+>>select uniq, c1000 from t1311k where uniq >2 and uniq <5;
+
+UNIQ         C1000      
+-----------  -----------
+
+          3            3
+          4            4
+
+--- 2 row(s) selected.
+>>select uniq, c1000 from t1311k where uniq >2 and uniq <99;
+
+UNIQ         C1000      
+-----------  -----------
+
+          3            3
+          4            4
+          5            5
+          6            6
+          7            7
+          8            8
+          9            9
+         10           10
+         11           11
+         12           12
+         13           13
+         14           14
+         15           15
+         16           16
+         17           17
+         18           18
+         19           19
+         20           20
+         21           21
+         22           22
+         23           23
+         24           24
+         25           25
+         26           26
+         27           27
+         28           28
+         29           29
+         30           30
+         31           31
+         32           32
+         33           33
+         34           34
+         35           35
+         36           36
+         37           37
+         38           38
+         39           39
+         40           40
+         41           41
+         42           42
+         43           43
+         44           44
+         45           45
+         46           46
+         47           47
+         48           48
+         49           49
+         50           50
+         51           51
+         52           52
+         53           53
+         54           54
+         55           55
+         56           56
+         57           57
+         58           58
+         59           59
+         60           60
+         61           61
+         62           62
+         63           63
+         64           64
+         65           65
+         66           66
+         67           67
+         68           68
+         69           69
+         70           70
+         71           71
+         72           72
+         73           73
+         74           74
+         75           75
+         76           76
+         77           77
+         78           78
+         79           79
+         80           80
+         81           81
+         82           82
+         83           83
+         84           84
+         85           85
+         86           86
+         87           87
+         88           88
+         89           89
+         90           90
+         91           91
+         92           92
+         93           93
+         94           94
+         95           95
+         96           96
+         97           97
+         98           98
+
+--- 96 row(s) selected.
+>>-- should get Small scanner off since the scanned rows do not fit in 64K block
+>>explain select * from t1311k where uniq >2 and uniq <30;
+
+------------------------------------------------------------------ PLAN SUMMARY
+MODULE_NAME .............. DYNAMICALLY COMPILED
+STATEMENT_NAME ........... NOT NAMED
+PLAN_ID .................. 212320281474599375
+ROWS_OUT ................ 29
+EST_TOTAL_COST ........... 0.01
+STATEMENT ................ select * from t1311k where uniq >2 and uniq <30;
+
+
+------------------------------------------------------------------ NODE LISTING
+ROOT ======================================  SEQ_NO 2        ONLY CHILD 1
+REQUESTS_IN .............. 1
+ROWS_OUT ................ 29
+EST_OPER_COST ............ 0
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est .......... 29
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  statement_index ........ 0
+  affinity_value ......... 0
+  max_max_cardinality ... 29
+  total_overflow_size .... 0.00 KB
+  xn_access_mode ......... read_only
+  xn_autoabort_interval    0
+  auto_query_retry ....... enabled
+  plan_version ....... 2,600
+  embedded_arkcmp ........ used
+  IS_SQLCI ............... ON
+  LDAP_USERNAME
+  HBASE_SMALL_SCANNER .... SYSTEM
+  GENERATE_EXPLAIN ....... ON
+  ObjectUIDs ............. 2727580673292039142
+  select_list ............ TRAFODION.SCH.T1311K.UNIQ,
+                             TRAFODION.SCH.T1311K.C1000,
+                             TRAFODION.SCH.T1311K.STR1
+
+
+TRAFODION_SCAN ============================  SEQ_NO 1        NO CHILDREN
+TABLE_NAME ............... T1311K
+REQUESTS_IN .............. 1
+ROWS_OUT ................ 29
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est .......... 29
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  scan_type .............. subset scan of table TRAFODION.SCH.T1311K
+  object_type ............ Trafodion
+  columns ................ all
+  begin_keys(excl) ....... 2
+  end_keys(excl) ........ 30
+  cache_size ........... 100
+  probes ................. 1
+  rows_accessed ......... 29
+  column_retrieved ....... #1:1,#1:2,#1:3
+  key_columns ............ UNIQ
+  executor_predicates .... (UNIQ > 2) and (UNIQ < 30)
+
+--- SQL operation complete.
+>>-- should get Small scanner on since the scanned rows fit in 128K block
+>>explain select * from t1311kbis where uniq >2 and uniq <30;
+
+------------------------------------------------------------------ PLAN SUMMARY
+MODULE_NAME .............. DYNAMICALLY COMPILED
+STATEMENT_NAME ........... NOT NAMED
+PLAN_ID .................. 212320281475934791
+ROWS_OUT ................ 29
+EST_TOTAL_COST ........... 0.01
+STATEMENT ................ select * from t1311kbis where uniq >2 and uniq <30;
+
+
+------------------------------------------------------------------ NODE LISTING
+ROOT ======================================  SEQ_NO 2        ONLY CHILD 1
+REQUESTS_IN .............. 1
+ROWS_OUT ................ 29
+EST_OPER_COST ............ 0
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est .......... 29
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  statement_index ........ 0
+  affinity_value ......... 0
+  max_max_cardinality ... 29
+  total_overflow_size .... 0.00 KB
+  xn_access_mode ......... read_only
+  xn_autoabort_interval    0
+  auto_query_retry ....... enabled
+  plan_version ....... 2,600
+  embedded_arkcmp ........ used
+  IS_SQLCI ............... ON
+  LDAP_USERNAME
+  HBASE_SMALL_SCANNER .... SYSTEM
+  GENERATE_EXPLAIN ....... ON
+  ObjectUIDs ............. 2727580673292041379
+  select_list ............ TRAFODION.SCH.T1311KBIS.UNIQ,
+                             TRAFODION.SCH.T1311KBIS.C1000,
+                             TRAFODION.SCH.T1311KBIS.STR1
+
+
+TRAFODION_SCAN ============================  SEQ_NO 1        NO CHILDREN
+TABLE_NAME ............... T1311KBIS
+REQUESTS_IN .............. 1
+ROWS_OUT ................ 29
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+  max_card_est .......... 29
+  fragment_id ............ 0
+  parent_frag ............ (none)
+  fragment_type .......... master
+  scan_type .............. subset scan of table TRAFODION.SCH.T1311KBIS
+  object_type ............ Trafodion
+  columns ................ all
+  begin_keys(excl) ....... 2
+  end_keys(excl) ........ 30
+  cache_size ........... 100
+  small_scanner .......... ON
+  probes ................. 1
+  rows_accessed ......... 29
+  column_retrieved ....... #1:1,#1:2,#1:3
+  key_columns ............ UNIQ
+  executor_predicates .... (UNIQ > 2) and (UNIQ < 30)
+
+--- SQL operation complete.
+>>
+>>exit;
+
+End of MXCI Session
+
+>>obey TEST131(clnup);
+>>drop table t131helper cascade;
+
+--- SQL operation complete.
+>>drop table t1311k cascade;
+
+--- SQL operation complete.
+>>drop table t1311kbis cascade;
+
+--- SQL operation complete.
+>>
+>>
+>>log;

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/executor/EXPECTED140
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED140 b/core/sql/regress/executor/EXPECTED140
index 6d70ca8..1683c92 100644
--- a/core/sql/regress/executor/EXPECTED140
+++ b/core/sql/regress/executor/EXPECTED140
@@ -53,7 +53,7 @@
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563691380188
+PLAN_ID .................. 212320281519143599
 ROWS_OUT ................ 33
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select a from t140 where b>500;
@@ -99,12 +99,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596819
+  ObjectUIDs ............. 5476465295937313773
   select_list ............ TRAFODION.SCH.T140.A
 
 
@@ -125,6 +126,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:3
@@ -151,7 +153,7 @@ A
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563692704671
+PLAN_ID .................. 212320281520763784
 ROWS_OUT ................ 33
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select an from t140b where b<=200;
@@ -197,12 +199,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596902
+  ObjectUIDs ............. 5476465295937313847
   select_list ............ TRAFODION.SCH.T140B.AN
 
 
@@ -223,6 +226,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:2,#1:6
@@ -236,7 +240,7 @@ DESCRIPTION
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563692850447
+PLAN_ID .................. 212320281520871425
 ROWS_OUT ................ 33
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select an from t140 where b<=200;
@@ -282,12 +286,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596819
+  ObjectUIDs ............. 5476465295937313773
   select_list ............ TRAFODION.SCH.T140.AN
 
 
@@ -308,6 +313,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:2,#1:6
@@ -332,7 +338,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563692995878
+PLAN_ID .................. 212320281520990973
 ROWS_OUT ................ 10
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select an from t140 where b=200 and an is not null;
@@ -378,12 +384,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596819
+  ObjectUIDs ............. 5476465295937313773
   select_list ............ TRAFODION.SCH.T140.AN
   input_variables ........ %(200)
 
@@ -405,6 +412,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:6
@@ -426,7 +434,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563693127204
+PLAN_ID .................. 212320281521112920
 ROWS_OUT ................ 67
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select an, a from t140 where b!=500;
@@ -472,12 +480,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596819
+  ObjectUIDs ............. 5476465295937313773
   select_list ............ TRAFODION.SCH.T140.AN, TRAFODION.SCH.T140.A
 
 
@@ -498,6 +507,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:3,#1:6
@@ -556,7 +566,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563693323114
+PLAN_ID .................. 212320281521342888
 ROWS_OUT ................ 10
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select an from t140 where bn=201 and an is not null;
@@ -602,12 +612,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596819
+  ObjectUIDs ............. 5476465295937313773
   select_list ............ TRAFODION.SCH.T140.AN
   input_variables ........ %(201)
 
@@ -629,6 +640,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:6
@@ -649,7 +661,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563693453818
+PLAN_ID .................. 212320281521467017
 ROWS_OUT ................ 67
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select an, a from t140 where bn!=501;
@@ -695,12 +707,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596819
+  ObjectUIDs ............. 5476465295937313773
   select_list ............ TRAFODION.SCH.T140.AN, TRAFODION.SCH.T140.A
 
 
@@ -721,6 +734,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:3,#1:6
@@ -794,7 +808,7 @@ A
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212319563693669223
+PLAN_ID .................. 212320281521680638
 ROWS_OUT ................ 11
 EST_TOTAL_COST ........... 0.05
 STATEMENT ................ select an from t140 where an between 20 and 40;
@@ -840,12 +854,13 @@ DESCRIPTION
   SEABASE_VOLATILE_TABLES  ON
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
+  HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
   TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 364316051091596819
+  ObjectUIDs ............. 5476465295937313773
   select_list ............ TRAFODION.SCH.T140.AN
 
 
@@ -866,6 +881,7 @@ DESCRIPTION
   begin_keys(incl)
   end_keys(incl)
   cache_size ........... 100
+  small_scanner .......... ON
   probes ................. 1
   rows_accessed ........ 100
   column_retrieved ....... #1:6

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/executor/FILTER131
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/FILTER131 b/core/sql/regress/executor/FILTER131
new file mode 100755
index 0000000..4a9a7ef
--- /dev/null
+++ b/core/sql/regress/executor/FILTER131
@@ -0,0 +1,31 @@
+#! /bin/sh
+# @@@ START COPYRIGHT @@@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+# @@@ END COPYRIGHT @@@
+
+# Like the pattern-masking of QACOMP, here we filter out such stuff as
+# transaction id.  Called by the runregr script before doing diff.
+
+fil=$1
+sed "
+s/^\([ ]*PLAN_ID[ ]*[\.]*\) .*/\1 removed/g
+s/^\([ ]*ObjectUIDs[ ]*[\.]*\) .*/\1 removed/g
+" $fil
+

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/executor/TEST131
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST131 b/core/sql/regress/executor/TEST131
new file mode 100644
index 0000000..898ddbe
--- /dev/null
+++ b/core/sql/regress/executor/TEST131
@@ -0,0 +1,96 @@
+-- Test: TEST131 (Executor)
+-- @@@ START COPYRIGHT @@@
+--
+--  Licensed under the Apache License, Version 2.0 (the "License");
+--  you may not use this file except in compliance with the License.
+--  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--  Unless required by applicable law or agreed to in writing, software
+--  distributed under the License is distributed on an "AS IS" BASIS,
+--  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--  See the License for the specific language governing permissions and
+--  limitations under the License.
+--
+-- @@@ END COPYRIGHT @@@
+--
+-- Functionality: Small Scanner and non regression for JIRA 1446 End key missing for simple scan scenario
+-- Expected files: EXPECTED131
+-- Table created: t131helper, t1311k, t1311kbis
+-- Limitations: 
+-- 
+-- To Do:   
+--      
+-- Revision history:
+--     (08/07/2015) - Created.
+-- 
+
+
+obey TEST131(clnup);
+
+log LOG131 clear;
+obey TEST131(setup);
+--reload new session to make sure we are not using cached histogram
+sh sh runmxci.ksh -i "TEST131(dml)";
+obey TEST131(clnup);
+log;
+exit;
+
+
+?section clnup
+drop table t131helper cascade;
+drop table t1311k cascade;
+drop table t1311kbis cascade;
+
+
+?section setup
+create table t131helper (a int not null, primary key(a));
+insert into t131helper values(1);
+create table t1311k (uniq int not null,
+					c1000 int,
+					str1 varchar(4000),
+					primary key (uniq));
+insert into t1311k
+  select (100*x100)+(10*x10)+x1,
+  		 (100*x100)+(10*x10)+x1,
+  		 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
+  from t131helper
+  		transpose 0,1,2,3,4,5,6,7,8,9 as x100
+  		transpose 0,1,2,3,4,5,6,7,8,9 as x10
+  		transpose 0,1,2,3,4,5,6,7,8,9 as x1;
+
+update statistics for table t1311k on every column sample 10 rows;
+
+--t1311kbis has twice the block size as t1311k that has default hbase block size of 64K  				 					      
+create table t1311kbis (uniq int not null,
+					c1000 int,
+					str1 varchar (4000),
+					primary key (uniq))
+					HBASE_OPTIONS (BLOCKSIZE='131072');
+insert into t1311kbis
+  select (100*x100)+(10*x10)+x1,
+  		 (100*x100)+(10*x10)+x1,
+  		 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
+  from t131helper
+  		transpose 0,1,2,3,4,5,6,7,8,9 as x100
+  		transpose 0,1,2,3,4,5,6,7,8,9 as x10
+  		transpose 0,1,2,3,4,5,6,7,8,9 as x1;
+
+update statistics for table t1311kbis on every column sample 10 rows;
+
+?section dml
+log LOG131;
+-- need set CQD since invoking this section using a new sh session to force statistic to be taken into account
+-- suspect this is because histogram is cached per session and we are starting a new session, reloading Histogram...
+cqd hbase_small_scanner 'SYSTEM';
+-- should have small scanner on and endKey populated (JIRA 1446)
+explain select * from t1311k where uniq >2 and uniq <5;
+explain select * from t1311k where uniq >2 and uniq <99;
+select uniq, c1000 from t1311k where uniq >2 and uniq <5;
+select uniq, c1000 from t1311k where uniq >2 and uniq <99;
+-- should get Small scanner off since the scanned rows do not fit in 64K block
+explain select * from t1311k where uniq >2 and uniq <30;
+-- should get Small scanner on since the scanned rows fit in 128K block
+explain select * from t1311kbis where uniq >2 and uniq <30;
+

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/fullstack2/EXPECTED062
----------------------------------------------------------------------
diff --git a/core/sql/regress/fullstack2/EXPECTED062 b/core/sql/regress/fullstack2/EXPECTED062
index 03229d0..ca88f6d 100644
--- a/core/sql/regress/fullstack2/EXPECTED062
+++ b/core/sql/regress/fullstack2/EXPECTED062
@@ -67,19 +67,19 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/xxxx/xxxx/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/export/bin64d/mxcierr ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2015-03-19 10:15}
+MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected
 SQL USER DB NAME   DB__ROOT
 SQL USER ID        33333
 TERMINAL CHARSET   ISO88591
-TRANSACTION ID
+TRANSACTION ID     
 TRANSACTION STATE  not in progress
 WARNINGS           on
 >>
@@ -498,7 +498,8 @@ CONTROL QUERY DEFAULT
   SEABASE_VOLATILE_TABLES       	ON
   HBASE_ASYNC_DROP_TABLE        	OFF
   HBASE_SERIALIZATION           	ON
-  HBASE_FILTER_PREDS            	ON
+  HBASE_SMALL_SCANNER           	SYSTEM
+  HBASE_FILTER_PREDS            	2
   TRAF_INDEX_CREATE_OPT         	ON
   SHOWCONTROL_SHOW_ALL          	ON
   SCHEMA                        	AAA.BBB
@@ -541,7 +542,8 @@ CONTROL QUERY DEFAULT
   SEABASE_VOLATILE_TABLES       	ON
   HBASE_ASYNC_DROP_TABLE        	OFF
   HBASE_SERIALIZATION           	ON
-  HBASE_FILTER_PREDS            	ON
+  HBASE_SMALL_SCANNER           	SYSTEM
+  HBASE_FILTER_PREDS            	2
   TRAF_INDEX_CREATE_OPT         	ON
   SHOWCONTROL_SHOW_ALL          	ON
   DEF_CHUNK_SIZE                	1000
@@ -575,7 +577,8 @@ CONTROL QUERY DEFAULT
   SEABASE_VOLATILE_TABLES       	ON
   HBASE_ASYNC_DROP_TABLE        	OFF
   HBASE_SERIALIZATION           	ON
-  HBASE_FILTER_PREDS            	ON
+  HBASE_SMALL_SCANNER           	SYSTEM
+  HBASE_FILTER_PREDS            	2
   TRAF_INDEX_CREATE_OPT         	ON
   SHOWCONTROL_SHOW_ALL          	ON
   DEF_CHUNK_SIZE                	1000
@@ -928,19 +931,19 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/xxxx/xxxx/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/export/bin64d/mxcierr ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2015-03-19 10:15}
+MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected
 SQL USER DB NAME   DB__ROOT
 SQL USER ID        33333
 TERMINAL CHARSET   ISO88591
-TRANSACTION ID
+TRANSACTION ID     
 TRANSACTION STATE  not in progress
 WARNINGS           on
 >>							-- *not* $$TEST_SCHEMA$$
@@ -992,19 +995,19 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/xxxx/xxxx/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/export/bin64d/mxcierr ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2015-03-19 10:15}
+MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected
 SQL USER DB NAME   DB__ROOT
 SQL USER ID        33333
 TERMINAL CHARSET   ISO88591
-TRANSACTION ID
+TRANSACTION ID     
 TRANSACTION STATE  not in progress
 WARNINGS           on
 >>						-- still not $$TEST_SCHEMA$$
@@ -1052,19 +1055,19 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/xxxx/xxxx/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/export/bin64d/mxcierr ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2015-03-19 10:15}
+MESSAGEFILE VRSN   {2016-01-23 00:47 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected
 SQL USER DB NAME   DB__ROOT
 SQL USER ID        33333
 TERMINAL CHARSET   ISO88591
-TRANSACTION ID
+TRANSACTION ID     
 TRANSACTION STATE  not in progress
 WARNINGS           on
 >>                                                    -- back to $$TEST_SCHEMA$$

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/49a06f8b/core/sql/regress/fullstack2/EXPECTED062.RELEASE
----------------------------------------------------------------------
diff --git a/core/sql/regress/fullstack2/EXPECTED062.RELEASE b/core/sql/regress/fullstack2/EXPECTED062.RELEASE
index 9423bfd..4b48a87 100644
--- a/core/sql/regress/fullstack2/EXPECTED062.RELEASE
+++ b/core/sql/regress/fullstack2/EXPECTED062.RELEASE
@@ -67,12 +67,12 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/rmarton/git_ws/core/sql/regress/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/sqf/export/bin64/mxci ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2014-08-28 15:32} 
+MESSAGEFILE VRSN   {2016-01-25 17:04 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected
@@ -498,7 +498,8 @@ CONTROL QUERY DEFAULT
   SEABASE_VOLATILE_TABLES       	ON
   HBASE_ASYNC_DROP_TABLE        	OFF
   HBASE_SERIALIZATION           	ON
-  HBASE_FILTER_PREDS            	ON
+  HBASE_SMALL_SCANNER           	SYSTEM
+  HBASE_FILTER_PREDS            	2
   TRAF_INDEX_CREATE_OPT         	ON
   SHOWCONTROL_SHOW_ALL          	ON
   SCHEMA                        	AAA.BBB
@@ -541,7 +542,8 @@ CONTROL QUERY DEFAULT
   SEABASE_VOLATILE_TABLES       	ON
   HBASE_ASYNC_DROP_TABLE        	OFF
   HBASE_SERIALIZATION           	ON
-  HBASE_FILTER_PREDS            	ON
+  HBASE_SMALL_SCANNER           	SYSTEM
+  HBASE_FILTER_PREDS            	2
   TRAF_INDEX_CREATE_OPT         	ON
   SHOWCONTROL_SHOW_ALL          	ON
   DEF_CHUNK_SIZE                	1000
@@ -575,7 +577,8 @@ CONTROL QUERY DEFAULT
   SEABASE_VOLATILE_TABLES       	ON
   HBASE_ASYNC_DROP_TABLE        	OFF
   HBASE_SERIALIZATION           	ON
-  HBASE_FILTER_PREDS            	ON
+  HBASE_SMALL_SCANNER           	SYSTEM
+  HBASE_FILTER_PREDS            	2
   TRAF_INDEX_CREATE_OPT         	ON
   SHOWCONTROL_SHOW_ALL          	ON
   DEF_CHUNK_SIZE                	1000
@@ -928,12 +931,12 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/rmarton/git_ws/core/sql/regress/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/sqf/export/bin64/mxci ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2014-08-28 15:32} 
+MESSAGEFILE VRSN   {2016-01-25 17:04 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected
@@ -994,12 +997,12 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/rmarton/git_ws/core/sql/regress/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/sqf/export/bin64/mxci ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2014-08-28 15:32} 
+MESSAGEFILE VRSN   {2016-01-25 17:04 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected
@@ -1054,12 +1057,12 @@ Current Environment
 ----------------------------------
 AUTHENTICATION     disabled
 AUTHORIZATION      enabled
-CURRENT DIRECTORY  /opt/home/rmarton/git_ws/core/sql/regress/rundir/fullstack2
+CURRENT DIRECTORY  /mnt/owhadi/workspace/trafodion/incubator-trafodion/core/sqf/rundir/fullstack2
 LIST_COUNT         4294967295
 LOG FILE           LOG062
-MESSAGEFILE        /opt/home/xxxx/xxxx/sqf/export/bin64/mxci ...
+MESSAGEFILE        /mnt/owhadi/workspace/trafodion/incubator-trafodion/cor ...
 MESSAGEFILE LANG   US English
-MESSAGEFILE VRSN   {2014-08-28 15:32} 
+MESSAGEFILE VRSN   {2016-01-25 17:04 LINUX:EDEV05/owhadi} 
 SQL CATALOG        TRAFODION
 SQL SCHEMA         SCH
 SQL USER CONNECTED user not connected


Mime
View raw message