Re: Dynamic Partitioning- Partition_Naming

2014-09-11 Thread Satish Mittal
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 w

Re: Dynamic Partitioning- Partition_Naming

2014-09-10 Thread Nitin Pawar
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

Re: Dynamic Partitioning- Partition_Naming

2014-09-09 Thread Nitin Pawar
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

Dynamic Partitioning- Partition_Naming

2014-09-08 Thread anusha Mangina
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_l