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
