Return-Path: X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B74AB102E4 for ; Mon, 6 Jan 2014 15:28:06 +0000 (UTC) Received: (qmail 60471 invoked by uid 500); 6 Jan 2014 15:28:06 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 60416 invoked by uid 500); 6 Jan 2014 15:28:05 -0000 Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.incubator.apache.org Delivered-To: mailing list dev@tajo.incubator.apache.org Received: (qmail 60407 invoked by uid 99); 6 Jan 2014 15:28:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Jan 2014 15:28:05 +0000 X-ASF-Spam-Status: No, hits=-2000.1 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 06 Jan 2014 15:28:03 +0000 Received: (qmail 53000 invoked by uid 99); 6 Jan 2014 15:26:50 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Jan 2014 15:26:50 +0000 Date: Mon, 6 Jan 2014 15:26:50 +0000 (UTC) From: "DaeMyung Kang (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (TAJO-474) Add query admin utility MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/TAJO-474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13863044#comment-13863044 ] DaeMyung Kang commented on TAJO-474: ------------------------------------ you can use admin tools like below: tajo admin -list tajo admin -desc tajo admin -cluster > 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)