目标:用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>
版本: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