Hive installation，

Hive installation，

目标：用mysql作为hive的metastore存储；
版本：hive-1.0.0;
环境：hadoop-2.4.1;

1、安装mysql 
#query all
rpm -qa | grep mysql
# remove mysql with no dependency 
rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps
#install
rpm -ivh MySQL-server-5.1.73-1.glibc23.i386.rpm 
rpm -ivh MySQL-client-5.1.73-1.glibc23.i386.rpm
#start/stop mysql
service mysql start
service mysql stop
#mysql setup
/usr/bin/mysql_secure_installation
#login
mysql -uroot -p123
#连接权限设置 *.*:所有库下的所有表；%：任何IP地址或主机都可以连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
FLUSH PRIVILEGES;

2、配置hive
2.1、解压hive.tar.gz
2.2、cp hive-default.xml.template hive-site.xml
修改hive-site.xml
<configuration>
<property>
 <name>javax.jdo.option.ConnectionURL</name>
 <value>jdbc:mysql://node04: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>123</value>
 <description>password to use against metastore database</description>
</property>
</configuration>

2.3 用./hadoop-2.4.1/share/hadoop/yarn/lib/jline-0.9.94.jar 替换hive原有的jline.jar

3、./apache-hive-1.0.0-bin/bin/hive 就可打开hive client