Hadoop HBase Hive | 四、Hive 搭建

目录

1.上一篇

2.上传 hive

3.修改hive-env.sh

4.修改hive-site.xml

5.修改hive-exec-log4j2.properties

6.修改hive-log4j2.properties

7.创建 文件夹

8.配置HBASE_HOME

9.初始化 hive

10.测试hive

11.启动hive

---

1.上一篇

Hadoop HBase Hive | 三、HBase 集群搭建

2.上传 hive

官网下载 http://mirrors.hust.edu.cn/apache/hive

上传 apache-hive-2.3.6-bin.tar.gz 至hadoop文件下

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

3.修改hive-env.sh

cd conf/

cp hive-env.sh.template hive-env.sh

vi hive-env.sh

4.修改hive-site.xml

cp hive-default.xml.template  hive-site.xml

把 ${system:java.io.tmpdir} 都修改成 /usr/local/hadoop-2.10.0/apache-hive-2.3.6-bin

把 ${system:user.name} 都换成hadoop-master

把 hive.server2.thrift.port 默认 10000 改成 8338

5.修改hive-exec-log4j2.properties

cp hive-exec-log4j2.properties.template hive-exec-log4j2.properties

6.修改hive-log4j2.properties

cp hive-log4j2.properties.template hive-log4j2.properties

7.创建 文件夹

./bin/hadoop fs -mkdir /tmp

./bin/hadoop fs -mkdir /user

./bin/hadoop fs -mkdir /user/hive

./bin/hadoop fs -mkdir /user/hive/warehourse

./bin/hadoop fs -chmod g+w /tmp

./bin/hadoop fs -chmod g+w /user/hive/warehourse

8.配置HBASE_HOME

vi ~/.bashrc  

export JAVA_HOME=/usr/java/jdk1.8.0_74

export HADOOP_HOME=/usr/local/hadoop-2.10.0

export HBASE_HOME=/usr/local/hadoop-2.10.0/hbase-2.2.2

export HIVE_HOME=/usr/local/hadoop-2.10.0/apache-hive-2.3.6-bin

export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_HOME/bin:$HBASE_HOME/bin:$HIVE_HOME/bin

source ~/.bashrc

9.初始化 hive

 ./bin/schematool -dbType derby -initSchema

10.测试hive

启动

     ./bin/hive

查看数据库

     show databases;

创建数据库

 create database test;

11.启动hive

mkdir logs

nohup ./bin/hiveserver2 &>logs/hive.log &

jps