Return-Path: Delivered-To: apmail-hive-dev-archive@www.apache.org Received: (qmail 13916 invoked from network); 2 Nov 2010 06:06:21 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 2 Nov 2010 06:06:21 -0000 Received: (qmail 345 invoked by uid 500); 2 Nov 2010 06:06:53 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 144 invoked by uid 500); 2 Nov 2010 06:06:51 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 136 invoked by uid 500); 2 Nov 2010 06:06:50 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 133 invoked by uid 99); 2 Nov 2010 06:06:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Nov 2010 06:06:50 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of prafulla.tekawade@gmail.com designates 209.85.214.176 as permitted sender) Received: from [209.85.214.176] (HELO mail-iw0-f176.google.com) (209.85.214.176) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Nov 2010 06:06:43 +0000 Received: by iwn7 with SMTP id 7so8576126iwn.35 for ; Mon, 01 Nov 2010 23:06:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received:from:date :x-google-sender-auth:message-id:subject:to:content-type; bh=DxGLoWWwwKg+ZUPR901L0XR36//FRLWVT80/1ywvMxc=; b=v+ydlh3oLms2yPtyluKjf619/qbFv9shywP4VAqHDXiJWAeNthskgyEAE0trdmQLfa ek30u8GxX+NBrM07fWw6R+Wwxb5OJXyQF94NQzONPycusPs04a6mMmfXbMMKz1ZTNdiC j9/DmAVIZJx6sL1Y6SB9k56XiAeNl/8wtksTI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:from:date:x-google-sender-auth:message-id :subject:to:content-type; b=D4eRTQzzRS/nCgLN1JKiaRPOgYUNlnz4xr4J7g/ort5wTlNSJGmHZT++F5FCxVo0WZ oMNhdnB5mdqoMXIrF9CkspPowLPHRQ2EsKtfaJt/cSJL3egxnQRi77KVfbx2wFVvz+gS k0OC5gAgnfzOUGtiH5WVDF4VlWyNlEcMiq7D8= Received: by 10.42.227.135 with SMTP id ja7mr2562207icb.155.1288677981623; Mon, 01 Nov 2010 23:06:21 -0700 (PDT) MIME-Version: 1.0 Sender: prafulla.tekawade@gmail.com Received: by 10.42.117.202 with HTTP; Mon, 1 Nov 2010 23:06:01 -0700 (PDT) From: Prafulla Tekawade Date: Tue, 2 Nov 2010 11:36:01 +0530 X-Google-Sender-Auth: EcTJqgQizLGiVSAJ6ootjE4kUgk Message-ID: Subject: Anyway in hive to measure query performance. To: hive-dev@hadoop.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi, I was wondering if there is anyway in hive that can be used to measure the performance of variour components/operations of a single query run. Eg. Typecally query involvs various operations like tablescan, joins, aggregation, orderby etc. Can I get how much time was required for each of this? Also how do you measure hadoop-cluster performance as far as hive query/load run is concerned ? -- Best Regards, Prafulla V Tekawade