六、hive与hbase的整合（hadoop01）

1.环境搭建

[root@hadoop01 ~]# vi /etc/profile
# HBASE_HOME
export HBASE_HOME=/export/servers/hbase-1.2.1
export PATH=$PATH:$HBASE_HOME/bin:

# HIVE_HOME
export HIVE_HOME=/export/servers/apache-hive-1.2.1-bin
export PATH=$PATH:$HIVE_HOME/bin:

[root@hadoop01 ~]# source /etc/profile

2.导入依赖

[root@hadoop01 servers]#  cd /export/servers/apache-hive-1.2.1-bin/lib/
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/hbase-common-1.2.1.jar /export/servers/apache-hive-1.2.1-bin/lib
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/hbase-server-1.2.1.jar /export/servers/apache-hive-1.2.1-bin/lib/
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/hbase-client-1.2.1.jar /export/servers/apache-hive-1.2.1-bin/lib/
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/hbase-protocol-1.2.1.jar  /export/servers/apache-hive-1.2.1-bin/lib/
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/hbase-it-1.2.1.jar /export/servers/apache-hive-1.2.1-bin/lib/
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/htrace-core-3.1.0-incubating.jar /export/servers/apache-hive-1.2.1-bin/lib/
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/hbase-hadoop2-compat-1.2.1.jar /export/servers/apache-hive-1.2.1-bin/lib/
[root@hadoop01 lib]# cp /export/servers/hbase-1.2.1/lib/hbase-hadoop-compat-1.2.1.jar /export/servers/apache-hive-1.2.1-bin/lib/

3.修改相关配置文件

[root@hadoop01 conf]# vi hive-site.xml

在其中加入一下内容(注意文件对其格式)
    <property>
      <name>hive.zookeeper.quorum</name>
      <value>hadoop01,hadoop02,hadoop03</value>
    </property>
    <property>
      <name>hive.zookeeper.client.port</name>
      <value>2181</value>
    </property>

4.启动相关服务

  启动hbase、hive、zookeeper、mysql、hadoop相关服务，命令如下：

#启动hadoop
start-all.sh

# 启动zookeeper
zkServer.sh start


#启动mysql
service mysqld start 

#启动hbase
start-hbase.sh

#启动hive
bin/hive