question CDH 7.1 : MSCK Repair is not working properly if delete the partitions path from HDFS in Support Questions

CDH 7.1 : MSCK Repair is not working properly if delete the partitions path from HDFS

DURAISAM — Mon, 26 Jul 2021 13:14:42 GMT

Use Case:

- Delete the partitions from HDFS by Manual

- Run MSCK repair

- HDFS and partition is in metadata -Not getting sync.

Tried multiple times and Not getting sync after upgrading CDH 6.x to CDH 7.x

Any solutions please

Re: CDH 7.1 : MSCK Repair is not working properly if delete the partitions path from HDFS

jAnshula — Mon, 26 Jul 2021 14:04:27 GMT

@DURAISAM

Can you share the error you have got when you had run the MSCK command.

Are you manually removing the partitions? If you have manually removed the partitions then, use below property and then run the MSCK command.

set hive.msck.path.validation=ignore

Re: CDH 7.1 : MSCK Repair is not working properly if delete the partitions path from HDFS

DURAISAM — Wed, 28 Jul 2021 07:58:05 GMT

Hi ,

Are you manually removing the partitions? Yes .

we cant use "set hive.msck.path.validation=ignore" because if we run msck repair .. automatically to sync HDFS folders and Table partitions right? this is not happening and no err.

our aim: Make HDFS path and partitions in table should sync in any condition