About Patriciabqc

Patriciabqc · ‎10-18-2024

Ok @MGreen , thanks for your help!

Patriciabqc · ‎10-16-2024

Yes, it seems to be this issue, but we already have 7.1.7 SP2 installed. Maybe SP3 fixed this issue... Thanks!

Patriciabqc · ‎10-16-2024

Patriciabqc · ‎10-15-2024

When I renamed the table, Hive renamed its HDFS directory, but it seemed that in the metastore database the partitions directories were not renamed. Maybe I needed to run some command to change the partitions locations in the metastore after renaming the table...

Patriciabqc · ‎10-11-2024

We use CDP 7.1.7. The table is 'external.table.purge'='true'. After the renames, when I dropped the table that was renamed to '_old' it affected the partitions of the one that was moved to the database and renamed to the same name as the other (before being renamed). As if they were both accessing the same directory.

Patriciabqc · ‎10-11-2024

Patriciabqc · ‎10-11-2024

I renamed a Hive partitioned table DB1.Tab1 to DB1.Tab1_old and then moved another table with the same name but from another database DB2.Tab1 to the first database DB1.Tab1, using the same rename command. It looks like the partitioned directories were merged because when I deleted the first renamed one (DB1.Tab1_old), the moved table partitions (DB1.Tab1) were deleted. I would like to understand why this happened. Regards

Online	Offline
Last Visited	‎10-25-2024 10:46 AM

Member Since	‎10-09-2024 10:48 AM
Last Visited	‎10-25-2024 10:46 AM
Posts	7
Kudos received	3

Cloudera Community

Re: Problem renaming Hive partitioned table and th...

Re: Problem renaming Hive partitioned table and th...

Re: Problem renaming Hive partitioned table and th...

Re: Problem renaming Hive partitioned table and th...

Re: Problem renaming Hive partitioned table and th...

Re: Problem renaming Hive partitioned table and th...

Problem renaming Hive partitioned table and then d...