Hive安装和配置详细过程

嵌入模式

进入software目录，上传并解压apache-hive-1.2.1-bin.tar安装包

cd /export/software
tar -zxvf apache-hive-1.2.1-bin.tar.gz -C /export/servers/

启动所有集群

start-all.sh

进入bin目录，启动hive程序

cd /export/servers/apache-hive-1.2.1-bin/
bin/hive

退出

exit;

下载MySQL,并启动

yum install mysql mysql-server mysql-devel  
/etc/init.d/mysqld start
mysql

修改用户名及密码

use mysql;
UPDATE user SET Password=PASSWORD('123456')WHERE user='root';

设置允许远程登录

GRANT ALL PRIVILEGES  ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

强制写入

FLUSH PRIVILEGES;

退出

exit;

退出mysql

exit;

下次重新进入mysql命令

mysql -u root -p

文件配置

修改hive-env.sh配置文件，配置Hadoop环境变量

cd /export/servers/apache-hive-1.2.1-bin/conf
cp hive-env.sh.template hive-env.sh

修改hive-env.sh文件

vi hive-env.sh

添加

export HADOOP_HOME=/export/servers/hadoop-2.7.4

添加hive-site.xml配置文件，配置MySQL相关信息

vi hive-site.xml

添加

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
	<property>
	    <name>javax.jdo.option.ConnectionURL</name>
	    <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
	    <description>
	      JDBC connect string for a JDBC metastore.
	      To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
	      For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
	    </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>123456</value>
	    <description>password to use against metastore database</description>
	  </property>
</configuration>

cd /export/servers/apache-hive-1.2.1-bin/lib

rz

先解压mysql-connector-java-5.1.46，在上传里面的jar包

初始化MYSQL数据库

cd /export/servers/apache-hive-1.2.1-bin/bin
./schematool -initSchema -dbType mysql

启动hive

cd /export/servers/apache-hive-1.2.1-bin/
bin/hive

退出hive

exit;

分发文件至02和03

scp -r /export/servers/apache-hive-1.2.1-bin hadoop02:/export/servers
scp -r /export/servers/apache-hive-1.2.1-bin hadoop03:/export/servers

xshell打开新的hadoop01页面

bin/hiveserver2
jps

在hadoop02执行，输入远程连接命令和协议，连接到指定HIve服务

cd /export/servers/apache-hive-1.2.1-bin/
bin/beeline

! connect jdbc:hive2://hadoop01:10000

输入，用户名root，密码123456

退出

！q

数据库操作

显示数据库

show databases;

创建名为itcast的数据库

create database if not exists itcast;
show databases;