You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2016/11/03 23:15:58 UTC

[jira] [Resolved] (TRAFODION-2322) UPDATE STATS for Hive TPC-H Lineitem table takes much longer now

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

David Wayne Birdsall resolved TRAFODION-2322.
---------------------------------------------
       Resolution: Fixed
    Fix Version/s: 2.1-incubating

> 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
>             Fix For: 2.1-incubating
>
>
> 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)