May 13, 2023

msck repair

 

  • hdfs dfs -rm -r /apps/hive/xyz/txnrecords_dp/category=Puzzles

  • Check if partition on hive

    • Show partitions txnrecords_dp;

    • Still it is available, metastore/hive will not recognize the HDFS changes

    • You have to make it recognize using msck repair command

  • How to sync from HDFS to MetaStore/Hive

    • hive> msck repair table txnrecords_dp;
Posted by at
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)