Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2322

UPDATE STATS for Hive TPC-H Lineitem table takes much longer now

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0-incubating
    • Fix Version/s: 2.1-incubating
    • Component/s: sql-cmp
    • Labels:
      None
    • Environment:
      All

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              dbirdsall Dave Birdsall
              Reporter:
              dbirdsall Dave Birdsall
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: