hive安装

环境

操作系统：rhel 6.5

软件版本：hive 2.1.0, mysql-5.5.62, mysql-connector-java-5.1.27.jar

步骤

1.创建用户，配置环境变量(root用户下）

useradd hadoop

passwd hadoop

2.安装hive,mysql(存放元数据)（root用户下）

vi /etc/profile

export HIVE_HOME=/usr/local/hive

export PATH=$PATH:$HIVE_HOME/bin

export MYSQL_HOME=/usr/local/mysql

export PATH=$PATH:$MYSQL_HOME/bin

source /etc/profile

mkdir /usr/local/hive

mkdir /usr/local/mysql

 

cd /tmp

tar -zxvf apache-hive-2.1.0-bin.tar.gz

tar -zxvf mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz

 

cp -r /tmp/apache-hive-2.1.0-bin/* /usr/local/hive

chown hadoop:hadoop /usr/local/hive -R

cp -r /tmp/mysql-5.5.62-linux-glibc2.12-x86_64/* /usr/local/mysql

cp /tmp/ mysql-connector-java-5.1.27.jar /usr/local/hive/lib

chown root:root /usr/local/mysql -R

chown -R hadoop:hadoop /usr/local/mysql/data 

chown hadoop:hadoop /var/lib/mysql -R

 

cd /usr/local/hive/conf

vi hive-site.xml

<?xml version="1.0"?>

<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>

<property>

<name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://127.0.0.1:3306/hive?characterEncoding=UTF-8</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>

<property>

<name>javax.jdo.option.ConnectionPassword</name>

<value>admin</value>

</property>

<property>

<name>hive.server2.enable.doAs</name>

<value>false</value>

</property>

</configuration>

vi /etc/my.cnf

user=hadoop

datadir=/usr/local/mysql/data

socket=/var/lib/mysql/mysql.sock

chown -R hadoop:hadoop /usr/local/hadoop

cd /usr/local/mysql

./scripts/mysql_install_db --user=hadoop --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

#安装mysql

chown -R root:root /usr/local/mysql

chown -R mysql:mysql /usr/local/mysql/data

cp support-files/mysql.server /etc/init.d/mysql

ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql

4.启动

hadoop用户下:

schematool -dbType mysql -initSchema 初始化数据库

service mysql start #启动数据库

mysqladmin -u root password 'admin'#更改数据库密码

mysql -u root -p #登陆数据库

create database hive; #创建名字为hive的数据库

hive --service metastore &

hive --service hiveserver2 &

hive #进入hive