[ 
https://issues.apache.org/jira/browse/TRAFODION-2027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liu ming closed TRAFODION-2027.
-------------------------------
    Resolution: Invalid

This is a misunderstanding, not a Trafodion issue.

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

Reply via email to