fanglinghe created TRAFODION-2707:
-------------------------------------
Summary: count(*) scans single region when it runs in parallel
Key: TRAFODION-2707
URL: https://issues.apache.org/jira/browse/TRAFODION-2707
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.2-incubating
Environment: All
Reporter: fanglinghe
count(*) executes in parallel but with a lower scanning cost in single region.
reproduce steps:
1> CREATE TABLE TRAFODION.BULKLOAD.TEST_A
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, B INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, C INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, D INT NO DEFAULT NOT NULL NOT DROPPABLE NOT
SERIALIZED
, PRIMARY KEY (A ASC, B ASC, C ASC, D ASC)
)
SALT USING 8 PARTITIONS
ON (A)
ATTRIBUTES ALIGNED FORMAT
;
2>explain select count(*) from test_a <<+ cardinality 1e7>> where a = 1;
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
