[持續更新]hive異常解決方案

1. hive日誌資訊檢視

###檔案路徑

• /tmp/<user.name>/hive.log
• 預設user.name為root
  
  

2. 載入資料失敗

報錯提示

Loading data to table default.test01
Failed with exception Unable to move source file:/root/hive_test.txt to destination hdfs://bigdata01:9000/user/hive/warehouse/test01/hive_test_copy_1.txt
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
複製程式碼

異常原因

• datanode沒有正常啟動

解決方案

• 重啟Hadoop叢集
  
  

3. 載入驅動失敗

報錯提示

Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
	at org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver(AbstractConnectionPoolFactory.java:58)
	at org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool(BoneCPConnectionPoolFactory.java:54)
	at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:213)
複製程式碼

異常原因

• 缺少MySQL驅動包

解決方案

• 上傳mysql驅動包到hive的lib目錄下