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/10/31 18:20:59 UTC

[jira] [Updated] (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 updated TRAFODION-2322:
--------------------------------------------
    Summary: UPDATE STATS for Hive TPC-H Lineitem table takes much longer now  (was: UPDATE STATS for ORC TPC-H Lineitem table takes much longer now)

> 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 ORC 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)