Hi, HIVE-6109 added support for providing custom path pattern when dynamic partitions are added through HCatalog APIs. However that feature is not yet available when issuing Hive queries. I have created a JIRA HIVE-8053 to track it.
Thanks, Satish On Thu, Sep 11, 2014 at 9:01 AM, Nitin Pawar <nitinpawar...@gmail.com> wrote: > 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 <nitinpawar...@gmail.com> > 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 <anusha.mang...@gmail.com> >> 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 > -- _____________________________________________________________ The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The firm is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.