hive 安装出现问题，各位帮忙看看

本帖最后由 pig2 于 2015-8-11 07:18 编辑

hadoop 2.6 64位
apache-hive-1.0.1-bin.tar.gz
mysql-connector-java-5.1.36-bin.jar

配置文件
[mw_shl_code=actionscript3,true]<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
<description>password to use against metastore database</description>
</property>
</configuration>
[/mw_shl_code]

hive> show databases;
OK
default
hivedb
kk
Time taken: 0.474 seconds, Fetched: 3 row(s)
hive> create table t123(id int,name string);
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)
hive>

einhep · 发表于 2017-4-15 20:19:38

这个需要进入mysql查看日志。
可能是mysql编码的问题。

进入mysql修改编码
alter database hive character set latin1;

可能遇到下面问题
ERROR 1 (HY000): Can't create/write to file './hive/db.opt' (Errcode: 2 - No such file or directory)

1) 创建目录 /var/lib/mysql/tmp

2)授权 chown mysql:mysql /var/lib/mysql/tmp

3) 在/etc/my.cnf中 [mysqld] 部分添加: tmpdir = /var/lib/mysql/tmp

4) 重启mysql

Alkaloid0515 · 发表于 2015-8-11 07:22:37

mysql-connector-java-5.1.36-bin.jar,这个jar包有问题或则不兼容，建议下载一个适合的jar包将jar包放入 hive的安装目录中的lib下面之前的删掉即可

arsenduan · 发表于 2015-8-11 09:59:19

楼主试试这两个包
mysql-connector-java-5.1.21.jar
链接: http://pan.baidu.com/s/1pJkDxpT 密码: ef8l

mysql-connector-java-5.1.10.jar
链接: http://pan.baidu.com/s/1bn4EIoZ 密码: weph

996981912 · 发表于 2015-8-11 11:24:00

把localhost改为ip地址~~~

kaka100 · 发表于 2015-8-11 19:28:31

谢谢回复，我试试

kaka100 · 发表于 2015-8-11 20:16:25

jar 都换了还是不行

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)