you can assume that everything that goes through CommandProcessor is an operation and the rest is an sql operation
https://github.com/apache/hive/blob/master/service/src/java/org/apache/hive/service/cli/operation/ExecuteStatementOperation.java#L88 https://github.com/apache/hive/blob/7b3ecf617a6d46f48a3b6f77e0339fd4ad95a420/ql/src/java/org/apache/hadoop/hive/ql/processors/CommandProcessorFactory.java hope that helps Am Do., 11. Aug. 2022 um 13:42 Uhr schrieb Struhar, Peter < [email protected]>: > hello HIVE team, > > I have couple of questions to HIVE metrics exposed via UI, hive version > 3.1.3 in this case. > I wanted originally to gather/chart via the metrics dump number of > operations done on hive server. > In the UI I have found out 2 to me interesting metrics, operations and sql > operations, however in the documentation on age > https://cwiki.apache.org/confluence/display/Hive/Hive+Metrics, I have not > found any explanation/description, what those metrics represent. > > Could someone maybe describe, what is/increments operations and sql > operations metrics and if there is some relation between those 2 types, > like sql operations is subset of operations ? > > In the JSON metric dump, those look like (N being some number): > > "hs2_completed_operation_CLOSED": N, > "hs2_completed_operation_ERROR": N, > "hs2_completed_operation_FINISHED": N, > "hs2_completed_sql_operation_CLOSED": N, > "hs2_completed_sql_operation_ERROR": N, > "hs2_completed_sql_operation_FINISHED": N, > > many thanks in advance > br/Peter > > ___________________________________________________________________________________ > Notice: This e-mail and any attachments are confidential and may be > privileged. If you are not the intended recipient, notify the sender > immediately, destroy all copies from your system and do not disclose or use > the information for any purpose. > > Diese E-Mail inklusive aller Anhaenge ist vertraulich und koennte > bevorrechtigtem > Schutz unterliegen. Wenn Sie nicht der beabsichtigte Adressat sind, > informieren Sie > bitte den Absender unverzueglich, loeschen Sie alle Kopien von Ihrem System > und > veroeffentlichen Sie oder nutzen Sie die Information keinesfalls, gleich zu > welchem Zweck. > > Think before you print! > > T-Mobile Austria GmbH > Geschaeftsfuehrung: Dr. Andreas Bierwirth (Vorsitzender), Aufsichtsrat: Kyra > Orth (Vorsitzende) > > Firmenbuch: Handelsgericht Wien, Sitz Wien, FN 171112k, UID ATU 45011703, DVR > 0898295 > Konto: UniCredit Bank Austria AG IBAN: AT93 1200 0528 4407 2301, BIC: BKAUATWW > > ___________________________________________________________________________________ > >
