安装包:apache-hive-0.13.1-bin.tar.gz
tar−zxfapache−hive−0.13.1−bin.tar.gz
cd /opt/modules/apache-hive-0.13.1-bin/conf
cphive−env.sh.templatehive−env.sh
vi hive-env.sh
添加如下三行:
export JAVA_HOME=/usr/java/jdk1.7.0_79
export HIVE_HOME=/opt/modules/apache-hive-0.13.1-bin
export HADOOP_HOME=/opt/modules/hadoop-2.5.0
cphive−default.xml.templatehive−site.xml
vi hive-site.xml
添加mysql数据库配置:
javax.jdo.option.ConnectionURL
jdbc:mysql://192.168.181.132:3306/matestore?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
123456
password to use against metastore database
并且把mysql驱动包复制到/opt/modules/apache-hive-0.13.1-bin/lib。
添加环境变量:
vi/etc/profile添加内容:exportHIVEHOME=/opt/modules/apache−hive−0.13.1−binexportPATH=
HIVE_HOME/bin:
PATH
source /etc/profile
安装完成,验证:
$ hive
如图:
注:
验证过程中出现了报错:
如下:
解决办法:
登录mysql服务器,进入mysql命令行,执行如下命令:
mysql> set global binlog_format=’MIXED’;
如下:
DONE!