[
https://issues.apache.org/jira/browse/TRAFODION-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15630988#comment-15630988
]
David Wayne Birdsall commented on TRAFODION-2322:
-------------------------------------------------
Note: While fixing this bug, I encountered another bug: If you do an UPDATE
STATISTICS CREATE SAMPLE on a table with a SYSKEY and with a long column, we
fail with a duplicate SYSKEY column error, because the code that constructs the
CREATE TABLE AS SELECT does not recognize that SYSKEY is a system column. This
bug was fixed in the pull request.
> 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)
