今天使用Sqoop 实现Hive 数据导入MySQL 8 提示错误信息如下:
Loading data to table default.hivetomysql
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Directory hdfs://Hadoop3-master:9000/user/hive/warehouse/hivetomysql could not be cleaned up.
造成原因:更新hiveTomysql 表中的数据,我清空了default.hiveTomysql 表记录,但是Hive 元数据存在记录导致从新导入数据失败。
解决办法:删除表重新导入数据
hive> drop table default.hiveTomysql;
OK
Time taken: 0.916 seconds
hive> use default;
OK
Time taken: 0.07 seconds
hive> CREATE TABLE IF NOT EXISTS hiveTomysql(sid INT,sname string,gender string, age int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
OK
Time taken: 1.071 seconds
hive> load data local inpath '/usr/local/tmp/hiveTomysql' overwrite into table default.hiveTomysql;
Loading data to table default.hivetomysql
OK
Time taken: 1.325 seconds