本文主要介绍在centOS中安装配置hive,hive依赖于hadoop及数据库(本文采用mysql),假定hadoop已经安装完成。
1.安装MySQL数据库
1.1删除系统自带MySQL
rpm -qa|grep mysql
rpm -e --nodeps [name]
1.2安装MySQL
rpm -ivh MySQL-server-5.5.30-1.linux2.6.x86_64.rpm
rpm -ivh MySQL-client-5.5.30-1.linux2.6.x86_64.rpm
1.3启动MySQL
service mysql start
1.4设定初始root密码
mysqladmin -u root password "root"
1.5使用root用户登录mysql,进入交互环境
mysql -u root -p
root
1.6配置用户远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'T1'IDENTIFIED BY 'root' WITH GRANT OPTION; #mysql 会将T1自动改写成t1
update mysql.user set Host='T1' where Host='t1' #将t1=>T1
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'T1'IDENTIFIED BY 'root' WITH GRANT OPTION; #mysql 会将T1自动改写成t1
update mysql.user set Host='T1' where Host='t1' #将t1=>T1
FLUSH PRIVILEGES;
"T1"是主机名
1.7将mysql-connector-java-5.1.39-bin.jar拷贝到apache-hive-1.2.1-bin/lib目录下
2.安装配置hive
2.1解压apache-hive-1.2.1-bin.zip
2.2创建hive-site.xml
配置文件目录:$HIVE_HOME/conf
<configuration>
<!-- 连接数据库密码 -->
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
</property>
<!-- 连接数据库字符串 -->
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://dky1:3306/hive?createDatabaseIfNotExist=tru
e</value>
</property>
<!-- 数据库驱动类名 -->
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<!-- 连接数据库用户 -->
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
</configuration>
2.3环境变量追加hive
a. 执行命令 vim /etc/profile,追加以下内容
export HIVE_HOME=/usr/bigdata/apache-hive-1.2.1-bin
export PATH=$PATH:$HIVE_HOME/bin
b.使修改后的环境变量立即生效,执行命令 source /etc/profile
2.4.启动hive
进入bin目录,执行hive命令 ./hive
2.5.常见错误
如果报错java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected
打开hadoop/etc/hadoop/hadoop-env.sh,增加export HADOOP_USER_CLASSPATH_FIRST=true
2.6.验证是否成功
进入mysql的hive数据库,使用show tables,显示如下结果
2.7.hive安装成功。
相关文章