Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B4AD4EED6 for ; Thu, 17 Jan 2013 06:39:21 +0000 (UTC) Received: (qmail 42429 invoked by uid 500); 17 Jan 2013 06:39:20 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 41594 invoked by uid 500); 17 Jan 2013 06:39:16 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 41341 invoked by uid 99); 17 Jan 2013 06:39:15 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Jan 2013 06:39:15 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [213.199.154.140] (HELO db3outboundpool.messaging.microsoft.com) (213.199.154.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Jan 2013 06:39:04 +0000 Received: from mail105-db3-R.bigfish.com (10.3.81.238) by DB3EHSOBE006.bigfish.com (10.3.84.26) with Microsoft SMTP Server id 14.1.225.23; Thu, 17 Jan 2013 06:38:43 +0000 Received: from mail105-db3 (localhost [127.0.0.1]) by mail105-db3-R.bigfish.com (Postfix) with ESMTP id 90F19480301 for ; Thu, 17 Jan 2013 06:38:43 +0000 (UTC) X-Forefront-Antispam-Report: CIP:132.245.2.69;KIP:(null);UIP:(null);IPV:NLI;H:BN1PRD0712HT003.namprd07.prod.outlook.com;RD:none;EFVD:NLI X-SpamScore: -2 X-BigFish: PS-2(zz1443Ic85dh14ffIzz1ee6h1de0h1202h1e76h1d1ah1d2ahzz18c673hz2dh2a8h668h839hd25he5bhf0ah1288h12a5h12bdh137ah1441h1504h1537h153bh162dh1631h1758h1765h1155h) Received: from mail105-db3 (localhost.localdomain [127.0.0.1]) by mail105-db3 (MessageSwitch) id 1358404721216190_3312; Thu, 17 Jan 2013 06:38:41 +0000 (UTC) Received: from DB3EHSMHS013.bigfish.com (unknown [10.3.81.247]) by mail105-db3.bigfish.com (Postfix) with ESMTP id 31DA92601D5 for ; Thu, 17 Jan 2013 06:38:41 +0000 (UTC) Received: from BN1PRD0712HT003.namprd07.prod.outlook.com (132.245.2.69) by DB3EHSMHS013.bigfish.com (10.3.87.113) with Microsoft SMTP Server (TLS) id 14.1.225.23; Thu, 17 Jan 2013 06:38:41 +0000 Received: from [192.168.10.124] (115.160.224.66) by pod51018.outlook.com (10.255.196.36) with Microsoft SMTP Server (TLS) id 14.16.257.4; Thu, 17 Jan 2013 06:38:39 +0000 Message-ID: <50F79D61.7010909@smartek21.com> Date: Thu, 17 Jan 2013 12:12:41 +0530 From: venkatramanan User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/20130106 Thunderbird/17.0.2 MIME-Version: 1.0 To: Subject: Configure Hive in Cluster Content-Type: multipart/alternative; boundary="------------030304060500030901070600" X-Originating-IP: [115.160.224.66] X-OriginatorOrg: smartek21.com X-Virus-Checked: Checked by ClamAV on apache.org --------------030304060500030901070600 Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit Hi All, Am Newbie in apache hive. I have create a table and thats points to the HDFS Folder path and its takes 15 min to execute the simple "*select*" stmt, Can anyone suggest me for a best practices and performance improvement on hive. Thanks in Advance Venkat --------------030304060500030901070600 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit Hi All,

Am Newbie in apache hive. I have create a table and thats points to the HDFS Folder path and its takes 15 min to execute the simple "select" stmt, Can anyone suggest me for a best practices and performance improvement on hive.

Thanks in Advance

Venkat
--------------030304060500030901070600--