解压hive二进制包,并移动到相应安装目录下,我这里是/opt:
#tar -zxvf apache-hive-0.13.1-bin.tar.gz
#mv apache-hive-0.13.1-bin /opt/hive-0.13.1
拷贝/mnt下mysql驱动包到hive安装目录lib下:
#cp mysql-connector-java-5.1.22-bin.jar /opt/hive-0.13.1/lib/
进入hive conf/目录下,配置hive-env.sh及hive-site.xml文件:
#vim hive-env.sh
--修改以下两项:
HADOOP_HOME=/opt/hadoop
export HIVE_CONF_DIR=/opt/hive-0.13.1/conf
---------------------------------------------------------------------------
#vim hive-site.xml
编辑内容如下:
javax.jdo.option.ConnectionURL
jdbc:mysql://chavin.king:3306/metastore?createDatabaseIfNotExist=true
JDBC connect string for a JDBC metastore
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
Driver class name for a JDBC metastore
javax.jdo.option.ConnectionUserName
root
username to use against metastore database
javax.jdo.option.ConnectionPassword
mysql
password to use against metastore database
--hive安装完成。
现在可以通过bin/hive命令登录hive shell进行相应操作了。