[jira] [Created] (TRAFODION-2027) hbase_aggr not selected as plan for a full select count(*) query

["liu ming (JIRA)" <ji...@apache.org>]

liu ming created TRAFODION-2027:
-----------------------------------

             Summary: hbase_aggr not selected as plan for a full select count(*) query
                 Key: TRAFODION-2027
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2027
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: liu ming


when do a 
select count(*) from tbl;
query, it should push down the aggregation to hbase coprocessor, but seems not.

to reproduce:
CREATE TABLE T113B
  (
    UNIQ                             INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
      SERIALIZED
  , C100K                            INT DEFAULT NULL NOT SERIALIZED
  , C10K                             INT DEFAULT NULL NOT SERIALIZED
  , C1K                              INT DEFAULT NULL NOT SERIALIZED
  , C100                             INT DEFAULT NULL NOT SERIALIZED
  , C10                              INT DEFAULT NULL NOT SERIALIZED
  , C1                               INT DEFAULT NULL NOT SERIALIZED
   , primary key(uniq)
  )
--  STORE BY (UNIQ ASC)
  SALT USING 16 PARTITIONS
ATTRIBUTES ALIGNED FORMAT
;


upsert using load into t113b select
0 + (100000 * x100000) + (10000 * x10000) + (1000 * x1000) +
(100 * x100) + (10 * x10) +( 1 * x1),
0 + (10000 * x10000) + (1000 * x1000) + (100 * x100) +
(10 * x10) +( 1 * x1),
0 + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
0 + (100 * x100) + (10 * x10) + (1 * x1),
0 + (10 * x10) + (1 * x1),
0 + (1 * x1),
0
 from (values(0)) t
transpose 0,1,2,3,4,5,6,7,8,9 as x100000
transpose 0,1,2,3,4,5,6,7,8,9 as x10000
transpose 0,1,2,3,4,5,6,7,8,9 as x1000
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
transpose 0,1,2,3,4,5,6,7,8,9 as x0;


update statistics for table t113b on every column;

explain options 'f' select count(*) from t113b;





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)