This is an automated email from the ASF dual-hosted git repository.

github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/hive-site.git


The following commit(s) were added to refs/heads/asf-site by this push:
     new 6497dbd  deploy: ee3ca19e440bb720dc348a072084526e33200076
6497dbd is described below

commit 6497dbdcf46d23752fdec6d3c6f66d49b17804fb
Author: zabetak <[email protected]>
AuthorDate: Mon Jan 27 17:08:49 2025 +0000

    deploy: ee3ca19e440bb720dc348a072084526e33200076
---
 docs/latest/languagemanual-commands_34838882/index.html | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git a/docs/latest/languagemanual-commands_34838882/index.html 
b/docs/latest/languagemanual-commands_34838882/index.html
index e8f4999..e0c588b 100644
--- a/docs/latest/languagemanual-commands_34838882/index.html
+++ b/docs/latest/languagemanual-commands_34838882/index.html
@@ -188,6 +188,10 @@ ASF
 <td>compile <code>&lt;groovy string></code> AS GROOVY NAMED </td>
 <td>This allows inline Groovy code to be compiled and be used as a UDF (as of 
Hive <a href=https://issues.apache.org/jira/browse/HIVE-5252>0.13.0</a>). For a 
usage example, see <a 
href="https://cwiki.apache.org/confluence/download/attachments/27362054/HiveContrib-Nov13-groovy_plus_hive.pptx?version=1&modificationDate=1385171856000&api=v2";>Nov.
 2013 Hive Contributors Meetup Presentations – Using Dynamic Compilation with 
Hive</a>.</td>
 </tr>
+<tr>
+<td>show processlist</td>
+<td>Displays information about the operations currently running on 
HiveServer2. It helps to troubleshoot issues such as long running queries, 
connection starvation, etc. The command was introduced in <a 
href=https://issues.apache.org/jira/browse/HIVE-27829>HIVE-27829</a>.</td>
+</tr>
 </tbody>
 </table>
 <p>Sample Usage:</p>
@@ -197,6 +201,13 @@ ASF
   hive&gt; !ls;
   hive&gt; dfs -ls;
 
+</code></pre><pre tabindex=0><code>0: jdbc:hive2://localhost:10000&gt; show 
processlist;
++------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+-------------------+-------------------+---------------+
+| User Name  |  Ip Addr   | Execution Engine  |              Session Id        
       | Session Active Time (s)  | Session Idle Time (s)  |                    
  Query ID                      |  State   | Opened Timestamp  | Elapsed Time 
(s)  |  Runtime (s)  |
++------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+-------------------+-------------------+---------------+
+| hive       | 127.0.0.1  | mr                | 
66df357a-90bf-43cb-847f-279aa6df1c24  | 113                      | 7            
          | rtrivedi_20240709124106_d0f00d7a-6fab-4fcd-9f41-d53bb296275d | 
RUNNING  | 1720546866774     | 16                | Not finished  |
+| hive       | 127.0.0.1  | mr                | 
7daa873e-bb46-462e-bc38-94cb8d3e7c17  | 83                       | 29           
          | rtrivedi_20240709124106_2dc53c4c-e522-4aed-a969-3d48ac01ba81 | 
RUNNING  | 1720546866774     | 17                | Not finished  |
++------------+------------+-------------------+---------------------------------------+--------------------------+------------------------+----------------------------------------------------+----------+-------------------+-------------------+---------------+
 </code></pre>
 </div>
 </div>

Reply via email to