hive mysql 错误_mysql – Hive’无法改变表’错误

我将数据加载到表格时出现错误,感谢您的帮助.

hive> load data local inpath '/home/Xperttech/Desktop/datagen_10.txt' into table patient;

Copying data from file:/home/Xperttech/Desktop/datagen_10.txt

Copying file: file:/home/Xperttech/Desktop/datagen_10.txt

Loading data to table default.patient

Failed with exception Unable to alter table.

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

但是数据会正常插入.

它只发生在我使用mysql进行Metastore时.当我改回德比时,一切正常.

我确信mysql运行良好,来自hive的登录成功.

Hive日志：

2014-07-24 20:36:55,136 ERROR exec.Task (SessionState.java:printError(419)) - Failed with exception Unable to alter table.

org.apache.hadoop.hive.ql.metadata.HiveException: Unable to alter table.

at org.apache.hadoop.hive.ql.metadata.Hive.alterTable(Hive.java:387)

at org.apache.hadoop.hive.ql.metadata.Hive.loadTable(Hive.java:1448)