[ https://issues.apache.org/jira/browse/TRAFODION-2027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15495935#comment-15495935 ]
liu ming commented on TRAFODION-2027: ------------------------------------- not an issue in Trafodion. > 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 > Assignee: 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)