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 25ACA110DC for ; Thu, 11 Sep 2014 03:32:25 +0000 (UTC) Received: (qmail 56938 invoked by uid 500); 11 Sep 2014 03:32:22 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 56865 invoked by uid 500); 11 Sep 2014 03:32:22 -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 56855 invoked by uid 99); 11 Sep 2014 03:32:21 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Sep 2014 03:32:21 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of nitinpawar432@gmail.com designates 209.85.213.43 as permitted sender) Received: from [209.85.213.43] (HELO mail-yh0-f43.google.com) (209.85.213.43) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Sep 2014 03:32:16 +0000 Received: by mail-yh0-f43.google.com with SMTP id v1so3590480yhn.16 for ; Wed, 10 Sep 2014 20:31:55 -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 :content-type; bh=PDpEBQ1uBItsgHByrH7d2G1K4UGfSD27o0/ERgoAXJI=; b=AXJU144Hk5aN6jaBImuRhmWKM13lUfJ6C1oR9i2iGp7MU9d18YHWmGyh9Z+WozJKmf v+2hlFlmZPaXqWI/FinKfE1bppHJquucoVRD8+4VYWC5f0ZNChMCAH7JgquurD0iygCS mNvqINreLnIyQSPI+p86r/SRdh5P2V4MwGoGml7nx2fYTr8nxDAMZ1OqBuIL4gF+CmYA InGxbZ/sZxwT/lq5Ouu5HQdl+cyVujV+Lnfw6sz8STThEc4gohVPHrVlkUqJMOSTI0f7 8Grqpabc0N4ac4/Xvu+lqcypiGBn6IB5unKzPw3gB31dJZAD/OxRhWq/ctyYjhw0lUQ3 0XNQ== MIME-Version: 1.0 X-Received: by 10.236.140.11 with SMTP id d11mr45443451yhj.16.1410406315686; Wed, 10 Sep 2014 20:31:55 -0700 (PDT) Received: by 10.170.61.207 with HTTP; Wed, 10 Sep 2014 20:31:55 -0700 (PDT) In-Reply-To: References: Date: Thu, 11 Sep 2014 09:01:55 +0530 Message-ID: Subject: Re: Dynamic Partitioning- Partition_Naming From: Nitin Pawar To: "user@hive.apache.org" Content-Type: multipart/alternative; boundary=20cf303ea3e46f81620502c1cf75 X-Virus-Checked: Checked by ClamAV on apache.org --20cf303ea3e46f81620502c1cf75 Content-Type: text/plain; charset=UTF-8 Thanks for correcting me Anusha, Here are the links you gave me https://cwiki.apache.org/confluence/display/Hive/HCatalog+Config+Properties https://issues.apache.org/jira/secure/attachment/12622686/HIVE-6109.pdf On Tue, Sep 9, 2014 at 5:16 PM, Nitin Pawar wrote: > you can not modify the paths of partitions being created by dynamic > partitioning or rename them > Thats the default implementation for having column=value in path as > partition > > > On Tue, Sep 9, 2014 at 5:18 AM, anusha Mangina > wrote: > >> >> I need a table partitioned by country and then city . I created a table >> and INSERTed data from another table using dynamic partition. >> >> CREATE TABLE invoice_details_hive _partitioned(Invoice_Id >> double,Invoice_Date string,Invoice_Amount double,Paid_Date >> string)PARTITIONED BY(pay_country STRING,pay_location STRING); >> >> Everything worked fine. >> >> >> >> Partitions by default are named like pay_country="INDIA" and >> "pay_city="DELHI" etc in >> >> ../hive/warehouse/invoice_details_hive_partitioned/pay_country="INDIA"/pay_city="DELHI" >> >> >> can I get partition name as Just Column Value INDIA and DELHI ...not >> including column name ...like /hive/warehouse/invoice_details_hive >> _partitioned/INDIA/DELHI? >> >> Thanks in Advance >> >> >> > > > -- > Nitin Pawar > -- Nitin Pawar --20cf303ea3e46f81620502c1cf75 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

On Tue, Sep 9, 2014 at 5:16 PM, Nitin Pawar = <nitinpawar= 432@gmail.com> wrote:
you can not modify the paths of partitions being created by dyn= amic partitioning or rename them=C2=A0
Thats the default implementation= for having column=3Dvalue in path as partition=C2=A0

<= /div>

On Tue, Sep 9, 2014 at 5:18 AM, anusha Mangina <anusha.m= angina@gmail.com> wrote:

I need a table partitioned by count= ry and then city . I created a table and INSERTed data =C2=A0from another t= able using dynamic partition.

CREATE TABLE invoice= _details_hive _partitioned(Invoice_Id double,Invoice_Date string,Invoice_Am= ount double,Paid_Date string)PARTITIONED BY(pay_country STRING,pay_location= STRING);

Everything worked fine.



Partitions by default are named like= pay_country=3D"INDIA" and =C2=A0"pay_city=3D"DELHI&quo= t; etc in=C2=A0
../hive/warehouse/invoice_details_hive_partitione= d/pay_country=3D"INDIA"/pay_city=3D"DELHI"=C2=A0
<= div>

can I get partition name as Just Column V= alue =C2=A0INDIA and DELHI ...not including column name ...like =C2=A0/hive= /warehouse/invoice_details_hive _partitioned/INDIA/DELHI?

Thanks in Advance





--
Nitin Pawar



--
Nitin Pawar<= br>
--20cf303ea3e46f81620502c1cf75--