Return-Path: X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 116AF11CFA for ; Tue, 12 Aug 2014 18:24:51 +0000 (UTC) Received: (qmail 15291 invoked by uid 500); 12 Aug 2014 18:24:47 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 15157 invoked by uid 500); 12 Aug 2014 18:24:47 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 15145 invoked by uid 99); 12 Aug 2014 18:24:46 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Aug 2014 18:24:46 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [79.99.40.135] (HELO auth-smtp-02.streamline.net) (79.99.40.135) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Aug 2014 18:24:21 +0000 Received: by auth-smtp-02.streamline.net (Postfix, from userid 500) id DD61F17B1094; Tue, 12 Aug 2014 19:24:18 +0100 (BST) X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on auth-smtp-02.streamline.net Received: from [192.168.0.13] (0540509c.skybroadband.com [5.64.80.156]) (Authenticated sender: studio@chrismackenziephotography.co.uk) by auth-smtp-02.streamline.net (Postfix) with ESMTP id 5F15517B1090 for ; Tue, 12 Aug 2014 19:24:13 +0100 (BST) User-Agent: Microsoft-MacOutlook/14.4.3.140616 Date: Tue, 12 Aug 2014 19:24:12 +0100 Subject: Re: ulimit for Hive From: Chris MacKenzie To: Message-ID: Thread-Topic: ulimit for Hive References: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Hi Zhijie, ulimit is common between hard and soft ulimit The hard limit can only be set by a sys admin. It can be used for a fork bomb dos attack. The sys admin hard ulimit can be set per user i.e hadoop_user A user can add a line to their .profile file setting a soft -ulimit up to the hard limit. You can google how to do that You can check the ulimits like so: ulimit -H -a // hard limit ulimit -S -a // soft limit The max value for the hard limit is -unlimited. I currently have mine set to this as I was running out of processes (nproc) I don=B9t know about restarting, I think so. I don=B9t know about hive. Warm regards. Chris telephone: 0131 332 6967 email: studio@chrismackenziephotography.co.uk corporate: www.chrismackenziephotography.co.uk From: Zhijie Shen Reply-To: Date: Tuesday, 12 August 2014 18:33 To: , Subject: Re: ulimit for Hive + Hive user mailing list It should be a better place for your questions. On Mon, Aug 11, 2014 at 3:17 PM, Ana Gillan wrote: Hi, I=B9ve been reading a lot of posts about needing to set a high ulimit for file descriptors in Hadoop and I think it=B9s probably the cause of a lot of the errors I=B9ve been having when trying to run queries on larger data sets in Hive. However, I=B9m really confused about how and where to set the limit, so I have a number of questions: 1. How high is it recommended to set the ulimit? 2. What is the difference between soft and hard limits? Which one needs to be set to the value from question 1? 3. For which user(s) do I set the ulimit? If I am running the Hive query with my login, do I set my own ulimit to the high value? 4. Do I need to set this limit for these users on all the machines in the cluster? (we have one master node and 6 slave nodes) 5. Do I need to restart anything after configuring the ulimit? Thanks in advance, Ana --=20 Zhijie ShenHortonworks Inc. http://hortonworks.com/ CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.