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)