[jira] [Updated] (TAJO-474) Add query admin utility

["DaeMyung Kang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TAJO-474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

DaeMyung Kang updated TAJO-474:
-------------------------------

    Attachment: TAJO-474.patch

Hi, guys. I add TajoAdmin Tool.

it supports only 3 options now.(I hope it will be better.) and I think this is first step to make good admin tools)

-list : show current running queries.
-desc : show current running queries detail(this option is somewhat different hyunsik suggested)
-cluster: show cluster info

There are some examples.
-list

QueryId              State   StartTime            Query                         
-------------------- ------- -------------------- ------------------------------
q-1388906477541-0008 RUNNING 2014-01-07 00:22:59  select * from table1 where ...

-desc

Id: 1
Query Id: q-1388906477541-0009
Started Time: 2014-01-07 00:23:14
Query State: SUCCEED
Finished Time: 2014-01-07 00:23:16
Execution Time: 1.0 sec
Query Progress: 1.0
Query Statement:
select * from table1 where id > 3

-cluster
Query Master
============

Live  Dead  Tasks
----- ----- -----
1     0     0    

Live QueryMasters
=================

QueryMaster               Port  Query Heap       Status    
------------------------- ----- ----- ---------- ----------
charsyam-vm-main:28093    28092 0     889 MB     LIVE      


Worker
======

Live  Dead 
----- -----
1     0    

Live Workers
============

Worker                    Port  Tasks Mem        Disk       Heap         Status    
------------------------- ----- ----- ---------- ---------- ------------ ----------
charsyam-vm-main:28091    59690 0     0/1024     0.00/1.00  208/889 MB   LIVE      


Dead Workers
============

No Dead Workers



> Add query admin utility
> -----------------------
>
>                 Key: TAJO-474
>                 URL: https://issues.apache.org/jira/browse/TAJO-474
>             Project: Tajo
>          Issue Type: New Feature
>          Components: tools
>            Reporter: Hyunsik Choi
>            Assignee: DaeMyung Kang
>             Fix For: 0.8-incubating
>
>         Attachments: TAJO-474.patch
>
>
> We need query admin utility to list running queries, get a query detail, or kill a specified running query. The utility may have the following form:
> {code:title=query list}
> $ bin/tajo admin -list
> query id                  start time                 query
> q_xxx_xxx running  2014-01-02T13:45:00 select a,b,c ... ...
> q_xxx_xxx running  2014-01-02T13:47:00 select count(distinct ...
> {code}
> {code:title=query kill}
> $ bin/tajo admin -kill q_xxx_xxxx
> q_xxx_xxxx has been killed.
> {code}
> {code:title=query detail}
> $ bin/tajo admin -desc q_xxx_xxxx
> query id: q_xxx_xxxx
> submit user: hyunsik
> start time: 2014-01-01T13:46:50
> running time: 36 sec
> query statement: 
> SELECT a,b,c
> FROM ...
> query logical plan:
> ...
> distributed execution plan:
> ...
> {code}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)