[
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)
