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
