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 A3F5319DC2 for ; Wed, 6 Apr 2016 02:08:27 +0000 (UTC) Received: (qmail 79286 invoked by uid 500); 6 Apr 2016 02:08:26 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 78984 invoked by uid 500); 6 Apr 2016 02:08:25 -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 78757 invoked by uid 99); 6 Apr 2016 02:08:25 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Apr 2016 02:08:25 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5B15018056C for ; Wed, 6 Apr 2016 02:08:25 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id DRqrTqNyCSAF for ; Wed, 6 Apr 2016 02:08:24 +0000 (UTC) Received: from mail-vk0-f48.google.com (mail-vk0-f48.google.com [209.85.213.48]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 291E55FAE6 for ; Wed, 6 Apr 2016 02:08:24 +0000 (UTC) Received: by mail-vk0-f48.google.com with SMTP id c4so41173062vkb.3 for ; Tue, 05 Apr 2016 19:08:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=/ZTxhI4C+IL6VoK3+XSwr51xYho1THmLMZt6genDdvU=; b=nH/YOboQQNDsKoQMs3gi8Kaj0FuQQ4yH7wMIts+1/CGc2xOUfKh4t6L4xb2KSsMziw sG+Hk+SDl6qburZpguQEdmbfYqUI9MUVGob+HThp60JV3VPjw/voyZ5Yupi1wq0GDKPS 3ObkTpjiBYX4djRKltz6an/810JZSg7eOkFrQS3wVdMCRO+smOV/vb/XSTSJyNhtYAI6 gPhNnyM3bMPQYIwEbq+HzbH7Cq5b+AzrL/BDGlqVgXTs/4za5Vk9zyC/XFE/6s76JLnh j9oJb0ooy/LItjUzBfxo3gCzy+1icInMDQkjDcXrNWnp3J383metmW6kxft+ZmpnsMQs vJGw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=/ZTxhI4C+IL6VoK3+XSwr51xYho1THmLMZt6genDdvU=; b=Fnzupl0/WfjPIahHy333knTaQY7a5sZNw1Ak83nkNNXzJoqHaVJC0YadRPzJYF3r4x 6zjjALyxawa05aVwGop/VD1IC3jGAfk4IX25r8R/4wyJodN4lVte6lX+FhpdsVYeILyr V0r921/2aGvYVZI4dOjTSxTaTzXlRAoHyodoJck1lE6vbj6R+3h8kMg8SIkwzDHMXC+o 6ZL35KM9AOW5rO9qzwLKQatz9xjfwpU9b+g7HVNGqbD85NKnUmzKywf5Iwo/8t8Kl7dy IA/zTTUNbaRm7X0XIdnCj+7K/BqYd9maHHZF9vlF9cfZYgsso1VJUwufE2W3cM2XtzF0 avbQ== X-Gm-Message-State: AD7BkJK7mE7LVWhlhm284ea2IzIfAABhQE6EhB+qMJ4ojKPVacK49+H1O0swj6QirvFkZDE8uWpMjV3NDZfAmw== MIME-Version: 1.0 X-Received: by 10.176.64.167 with SMTP id i36mr10141911uad.120.1459908503315; Tue, 05 Apr 2016 19:08:23 -0700 (PDT) Received: by 10.31.50.8 with HTTP; Tue, 5 Apr 2016 19:08:23 -0700 (PDT) Received: by 10.31.50.8 with HTTP; Tue, 5 Apr 2016 19:08:23 -0700 (PDT) In-Reply-To: References: Date: Wed, 6 Apr 2016 07:38:23 +0530 Message-ID: Subject: Re: Dynamic Partitioning Table Properties From: bhanu prasad To: user@hive.apache.org Content-Type: multipart/alternative; boundary=94eb2c124610beaaf0052fc76fc5 --94eb2c124610beaaf0052fc76fc5 Content-Type: text/plain; charset=UTF-8 Thank u lefty On Apr 6, 2016 6:51 AM, "Lefty Leverenz" wrote: > These are configuration properties, not table properties. Here are their > descriptions in the Hive wiki: > > - hive.exec.dynamic.partition.mode > > - hive.exec.max.dynamic.partitions > > - hive.exec.max.dynamic.partitions.pernode > > > And there's more information in the Tutorial: Dynamic-Partition Insert > > . > > -- Lefty > > > On Mon, Apr 4, 2016 at 5:54 AM, bhanu prasad > wrote: > >> Hi, >> >> Can anyone explain me the below dynamic partitioning table properties in >> detail. >> >> >> >> 1.set hive.exec.dynamic.partition.mode=nonstrict; >> 2.set hive.exec.max.dynamic.partitions=10000; >> 3.set hive.exec.max.dynamic.partitions.pernode=500; >> >> >> Thanks in advance >> >> > --94eb2c124610beaaf0052fc76fc5 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Thank u lefty

On Apr 6, 2016 6:51 AM, "Lefty Leverenz&quo= t; <leftyleverenz@gmail.com> wrote:
These are configuration properties, not table properties.=C2=A0 = Here are their descriptions in the Hive wiki:
And there's more information in th= e Tutorial: =C2=A0Dynamic-Par= tition Insert.

<= div>
-- Lefty


On Mon, Apr 4, 2016 at 5:54 AM, bhanu prasad= <mail2bigdataprasad@gmail.com> wrote:
Hi,

Can anyone explain me the= below dynamic partitioning table properties in detail.



1.set hive.exec.dynamic.part=
ition.mode=3Dnonstrict;
2.set hive.exec.max.dynamic.partitions=3D10000;<=
br>3.set hive.exec.max.dynamic.partitions.pernode=3D500;

<=
/pre>
Thanks in advance

--94eb2c124610beaaf0052fc76fc5--