[
https://issues.apache.org/jira/browse/TRAFODION-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15634043#comment-15634043
]
ASF GitHub Bot commented on TRAFODION-2322:
-------------------------------------------
Github user zellerh commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/811#discussion_r86429502
--- Diff: core/sql/regress/seabase/EXPECTED040 ---
@@ -227,6 +262,122 @@ CREATE TABLE TRAFODION.T040SCH.T040NOSALTSAME
--- SQL operation complete.
>>
+>>create table t040limitedcols like t040bigcols
++>limit column length to 256;
+
+--- SQL operation complete.
+>>
+>>showddl t040limitedcols;
+
+CREATE TABLE TRAFODION.T040SCH.T040LIMITEDCOLS
+ (
+ A INT NO DEFAULT NOT NULL NOT DROPPABLE
+ , B CHAR(256) CHARACTER SET ISO88591
COLLATE
+ DEFAULT DEFAULT NULL
+ , C VARCHAR(256) CHARACTER SET ISO88591
+ COLLATE DEFAULT DEFAULT NULL
+ , D CHAR(256 BYTES) CHARACTER SET UTF8
COLLATE
+ DEFAULT DEFAULT NULL
+ , E VARCHAR(256 BYTES) CHARACTER SET UTF8
+ COLLATE DEFAULT DEFAULT NULL
+ , F CHAR(128) CHARACTER SET UCS2 COLLATE
+ DEFAULT DEFAULT NULL
+ , G VARCHAR(128) CHARACTER SET UCS2
COLLATE
+ DEFAULT DEFAULT NULL
+ , PRIMARY KEY (A ASC)
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+--- SQL operation complete.
+>>
+>>create table t040somelimitedcols like t040bigcols
++>limit column length to 1002;
+
+--- SQL operation complete.
+>>
+>>showddl t040somelimitedcols;
+
+CREATE TABLE TRAFODION.T040SCH.T040SOMELIMITEDCOLS
+ (
+ A INT NO DEFAULT NOT NULL NOT DROPPABLE
+ , B CHAR(1000) CHARACTER SET ISO88591
COLLATE
+ DEFAULT DEFAULT NULL
+ , C VARCHAR(1001) CHARACTER SET ISO88591
+ COLLATE DEFAULT DEFAULT NULL
+ , D CHAR(1002 BYTES) CHARACTER SET UTF8
+ COLLATE DEFAULT DEFAULT NULL
+ , E VARCHAR(1002 BYTES) CHARACTER SET UTF8
+ COLLATE DEFAULT DEFAULT NULL
+ , F CHAR(501) CHARACTER SET UCS2 COLLATE
+ DEFAULT DEFAULT NULL
+ , G VARCHAR(501) CHARACTER SET UCS2
COLLATE
+ DEFAULT DEFAULT NULL
+ , PRIMARY KEY (A ASC)
+ )
+ ATTRIBUTES ALIGNED FORMAT
+;
+
+--- SQL operation complete.
+>>
+>>create table t040fewerlimitedcols like t040bigcols
++>limit column length to 2010;
+
+--- SQL operation complete.
+>>
+>>showddl t040fewerlimitedcols;
+
+CREATE TABLE TRAFODION.T040SCH.T040FEWERLIMITEDCOLS
+ (
+ A INT NO DEFAULT NOT NULL NOT DROPPABLE
+ , B CHAR(1000) CHARACTER SET ISO88591
COLLATE
+ DEFAULT DEFAULT NULL
+ , C VARCHAR(1001) CHARACTER SET ISO88591
+ COLLATE DEFAULT DEFAULT NULL
+ , D CHAR(2010 BYTES) CHARACTER SET UTF8
+ COLLATE DEFAULT DEFAULT NULL
+ , E VARCHAR(2010 BYTES) CHARACTER SET UTF8
+ COLLATE DEFAULT DEFAULT NULL
+ , F CHAR(1004) CHARACTER SET UCS2 COLLATE
+ DEFAULT DEFAULT NULL
+ , G VARCHAR(1005) CHARACTER SET UCS2
COLLATE
+ DEFAULT DEFAULT NULL
+ , PRIMARY KEY (A ASC)
+ )
+ ATTRIBUTES ALIGNED FORMAT
--- End diff --
Maybe make one of these tables salted and/or divisioned and is is possible
to limit a key column?
> UPDATE STATS for Hive TPC-H Lineitem table takes much longer now
> ----------------------------------------------------------------
>
> Key: TRAFODION-2322
> URL: https://issues.apache.org/jira/browse/TRAFODION-2322
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.0-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> When using a LINEITEM table with about 12 million rows, and storing that
> LINEITEM table in Hive files, UPDATE STATISTICS has regressed in its
> performance. On one test system, the elapsed time changed from 6 minutes 20
> seconds to 31 minutes 31 seconds.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
