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

Posted to dev@hive.apache.org by "Taraka Rama Rao Lethavadla (Jira)" <ji...@apache.org> on 2022/11/03 17:32:00 UTC

[jira] [Created] (HIVE-26703) Group queries between HMS and backend database and make them available

Taraka Rama Rao Lethavadla created HIVE-26703:
-------------------------------------------------

             Summary: Group queries between HMS and backend database and make them available
                 Key: HIVE-26703
                 URL: https://issues.apache.org/jira/browse/HIVE-26703
             Project: Hive
          Issue Type: New Feature
          Components: Standalone Metastore
            Reporter: Taraka Rama Rao Lethavadla


While troubleshooting HMS slowness issue, we have to rely on logs to see which component(compaction/stats/client connections) are causing issue.

The proposal is to group the queries executed by HMS into component wise and expose number of queries each component is making at a given point in time like

Compaction - 15 queries

Client/HS2 - 4 queries

Msck - 10 queries

stats - 80 queries

So from the above numbers I could say that stats is consuming more connections/resources and try any action to reduce it

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)