Hi
The first idea pops up is:
1. HDFS commands to copy your existing structure and data to support a
new partitions structure.
2. Create a new on temporary hive external table
3. (optional) if you created temporary table then drop old one and
insert ... select from temporary table.
Margus (margusja) Roo
http://margus.roo.ee
skype: margusja
+372 51 48 780
On 06/06/16 06:02, raj hive wrote:
Hi friends,
I have created partitions on hive external tables. partitions on
datetime/userid/customerId.
now i have to change the order of the partitions for the existing data
for all the dates.
order of the partition is custerid/userid/datetime.
Anyone can help me, how to alter the partitions for the existing
table. Need a help to write a script to change the partions on
existing data. almost 3 months data is there to modify as per new
partition so changing each date is difficult. Any expert can help me.
Thanks
Raj
