You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:46:46 UTC
[jira] [Closed] (TRAFODION-1136) LP Bug: 1440985 - description of
esp_exchange operation doesn't have *h2-br* and *h2-ud*
[ https://issues.apache.org/jira/browse/TRAFODION-1136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-1136.
-------------------------------------
Resolution: Fixed
Change status in JIRA to closed to reflect LaunchPad
> LP Bug: 1440985 - description of esp_exchange operation doesn't have *h2-br* and *h2-ud*
> -----------------------------------------------------------------------------------------
>
> Key: TRAFODION-1136
> URL: https://issues.apache.org/jira/browse/TRAFODION-1136
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: zhang yan
> Assignee: Qifan Chen
> Fix For: 2.0-incubating
>
>
> SQL>set schema G_SKEWBUSTER;
> SQL>cqd comp_bool_158 'on';
> --- SQL operation complete.
> SQL>cqd SKEW_ROWCOUNT_THRESHOLD '0';
> --- SQL operation complete.
> SQL>Cqd SKEW_SENSITIVITY_THRESHOLD '0';
> --- SQL operation complete.
> SQL>prepare xx from select count(*) from fiso f, diso d where f.string20=d.stringvar and f.unique1 > 16000000;
> --- SQL command prepared.
> SQL>explain options 'f' xx;
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> ---- ---- ---- -------------------- -------- -------------------- ---------
> 8 . 9 root 1.00E+000
> 7 . 8 sort_partial_aggr_ro 1.00E+000
> 6 . 7 esp_exchange 1:20(hash2) 1.00E+000
> 5 . 6 sort_partial_aggr_le 1.00E+000
> 4 2 5 hybrid_hash_join 3.25E+006
> 3 . 4 esp_exchange 20(hash2):8(hash2) 1.62E+007
> . . 3 trafodion_scan FISO 1.62E+007
> 1 . 2 esp_exchange 20(hash2):8(hash2) 1.00E+006
> . . 1 trafodion_scan DISO 1.00E+006
> SQL>showddl fiso;
> CREATE TABLE TRAFODION.G_SKEWBUSTER.FISO
> (
> UNIQUE1 INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , ONEPERCENT INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , TENPERCENT INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , TWENTYPERCENT INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , FIFTYPERCENT INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , STRING1 CHAR(52) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRING10 CHAR(52) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRING20 CHAR(52) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRING50 CHAR(52) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRING1V VARCHAR(104) CHARACTER SET ISO88591
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRING10V VARCHAR(104) CHARACTER SET ISO88591
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRING20V VARCHAR(104) CHARACTER SET ISO88591
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRING50V VARCHAR(104) CHARACTER SET ISO88591
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , UNIQCHAR CHAR(104) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , UNIQVCHAR VARCHAR(104) CHARACTER SET ISO88591
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , PRIMARY KEY (UNIQUE1 ASC)
> )
> SALT USING 8 PARTITIONS
> ;
> --- SQL operation complete.
> SQL>showddl diso;
> CREATE TABLE TRAFODION.G_SKEWBUSTER.DISO
> (
> UNIQUE1 INT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , STRINGVAR VARCHAR(52) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , STRINGCHAR CHAR(52) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , PRIMARY KEY (UNIQUE1 ASC)
> )
> SALT USING 8 PARTITIONS
> ;
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)