hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Dynamic Partitioning- Partition_Naming
Date Thu, 11 Sep 2014 03:31:55 GMT
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 <nitinpawar432@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.mangina@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

Mime
View raw message