Hive笔记--安装
http://blog.csdn.net/superye1983
Hive的安装其实很简单下载tar包解压，然后配置一下HIVE_HOME和系统PATH就可以了
然后运行hive
Logging initialized using configuration in jar:file:/home/kira/src/hive/current/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/kira/hive_job_log_kira_201209101140_767693934.txt
看到以上信息就可以开始在命令行中使用Hive了
先试一下show tables;
结果报错：
FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
NestedThrowables:
java.lang.reflect.InvocationTargetException
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
这个错误出现的原因是Hive自带的lib中没有mysql的jar，我用的是mysql-connector-java-5.1.18-bin.jar，拷贝到HIVE_HOME/lib中
再运行，还是报错，这次错误信息不一样了
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: The connection property 'useUnicode' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;characterEncoding=UTF-8;createDatabaseIfNotExist=true' is not in this set.
NestedThrowables:
java.sql.SQLException: The connection property 'useUnicode' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true;characterEncoding=UTF-8;createDatabaseIfNotExist=true' is not in this set.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
这个提示还是很明确的，找到hive-site.xml中的
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?useUnicode=true;characterEncoding=UTF-8;createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
修改为
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?useUnicode=true&characterEncoding=UTF-8&createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
好了继续跑
又出错了
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Access denied for user 'root'@'localhost' (using password: YES)
NestedThrowables:
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
这次坑爹了，从terminal运行mysql -uroot -p是可以进去的呀
看了一下hive-site.xml，配置mysql用户名密码的信息为：
<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></value>
<description>password to use against metastore database</description>
</property>
没错呀我的用户名是root，密码为空
然后就是查是否是权限开放的有问题，于是各种GRANT，改user表，都试了一遍还是不行
由于我有很多其他项目在本地都是用的root和空这套用户名密码，所以从一开始就不想换用户名密码，也就导致所有的修改都没能成功的原因
后来想到是否是javax.jdo.option.ConnectionPassword配置为空导致hive的程序使用了NULL而非空字符串做密码呢
于是只能添加新的用户名密码了
进去mysql：mysql -uroot -p
输入密码
use mysql;
insert into user(Host,User,Password) values("localhost","hive",password("hive"));
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'localhost' IDENTIFIED BY 'hive' WITH GRANT OPTION;
FLUSH PRIVILEGES;
然后修改hive-site.xml
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
<description>password to use against metastore database</description>
</property>
再run，总算OK了
到此为止总算是能跑了，最后那个问题应该是和密码为空有关，但是否是上面所说的被hive改为了NULL，这点没有看源码，以后再认证吧！
我的hive版本hive-0.8.1
