Hive中将文件加载到数据库表失败解决办法(hive创建表失败)
遇到的问题:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: java.net.ConnectException Call From dblab-VirtualBox/127.0.1.1 to localhost:9000 failed on connection exception: java.net.ConnectException: 拒绝连接; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused)
解决办法:
登录所安装的数据库(我用的是mysql)
1、删除hive,
drop database hive;
2、重新创建hive,
create database hive;
3、将字符集UTF-8修改为 latin1,
alter database hive character set latin1;