Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-26143

Performance enhancements for highly concurrent use-cases

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Metastore
    • None

    Description

      These changes are from a recent high-concurrency test-run with 
       - 4x HS2 (each with dedicated HMS instances), each with up to 2k sessions
       - 1x HS2 (with dedicated HMS instance) for housekeeping (~all background tasks)

      The tests brought two issues to the surface:
       - missing indexes caused long running queries in the backend database (with table scans) which then lead to query locks
       - the notification log cleaners can't be configured to a single node 

      Attachments

        Activity

          People

            kovjanos Janos Kovacs
            kovjanos Janos Kovacs
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 3.5h
                3.5h