報錯

Failed with exception java.io.IOException:org.apache.hadoop.hdfs.BlockMissingException: Could not obtain block: BP-1921057509-192.168.57.129-1517160177567:blk_1073741930_1106 file=/user/hive/warehouse/db_hive.db/student/student.txt
Time taken: 0.104 seconds
hive> eixt;
NoViableAltException(26@[])

image.png

• hdfs檢測
  檢測命令：bin/hdfs fsck /

  
  

• 清理壞塊
  命令：bin/hdfs fsck / -delete
  命令說明：將丟失的塊全部刪除

• 檢測
  bin/hdfs fsck /

  
  

  health

• hive測試

  
  

  success