********************************* Administration Commands ********************************* ========== Synopsis ========== Tsql provides administration commands as follows: .. code-block:: sql default> \admin; usage: admin [options] -cluster Show Cluster Info -desc Show Query Description -h,--host Tajo server host -kill Kill a running query -list Show Tajo query list -p,--port Tajo server port -showmasters gets list of tajomasters in the cluster ----------------------------------------------- Basic usages ----------------------------------------------- ``-list`` option shows a list of all running queries as follows: :: default> \admin -list QueryId State StartTime Query -------------------- ------------------- ------------------- ----------------------------- q_1411357607375_0006 QUERY_RUNNING 2014-09-23 07:19:40 select count(*) from lineitem ``-desc`` option shows a detailed description of a specified running query as follows: :: default> \admin -desc q_1411357607375_0006 Id: 1 Query Id: q_1411357607375_0006 Started Time: 2014-09-23 07:19:40 Query State: QUERY_RUNNING Execution Time: 20.0 sec Query Progress: 0.249 Query Statement: select count(*) from lineitem ``-kill`` option kills a specified running query as follows: :: default> \admin -kill q_1411357607375_0007 q_1411357607375_0007 is killed successfully. ``-showmasters`` option shows a list of all tajo masters as follows: :: default> \admin -showmasters grtajo01