Hive环境搭建

Hive环境搭建

---

安装zookeeper

• 前置条件安装完hadoop集群

• 下载zookeeper,并解压

• 修改zoo.cfg

  • cp zoo_template.cfg zoo.cfg(此文件在conf文件夹下)

  • 修改zoo.cfg

    dataDir=/opt/soft/zk/tmp

• 配置环境变量

  • export ZOOKEEPR_HOME=/zookeeper解压路径

  • export PATH=$PATH:$ZOOKEEPER_HOEM/bin

---

安装hive

• 下载hive并解压

• cp hive-default.xml.template hive-site.xml(此文件在conf文件夹下)

• 修改hive-site.xml文件

• <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
  <configuration>
  	<property>
  		<name>hive.metastore.warehouse.dir</name>
  		<value>/usr/soft/apache-hive-1.2.2-bin/warehouse</value>
  	</property>
  	<property>
  		<name>hive.metastore.local</name>
  		<value>false</value>
  	</property>
  <!-- 如果是远程mysql数据库的话需要在这里写入远程的IP或hosts -->
  	<property>
  		<name>javax.jdo.option.ConnectionURL</name>
  		<value>jdbc:mysql://192.168.56.100:3306/hive?createDatabaseIfNotExist=true</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>root</value>
  	</property>
  	<property>
  		    <name>hive.server2.authentication</name>
  		    <value>NONE</value>
  	</property>
  	  <property>
  		    <name>hive.server2.thrift.client.user</name>
  		    <value>root</value>
   	 </property>
  	  <property>
  		    <name>hive.server2.thrift.client.password</name>
  		    <value>root</value>
  	  </property>
  </configuration>
  

---

启动hive

• 启动顺序hadoop>zookeeper>mysql>hive

  • start-all.sh
  • zkServer.sh start
  • service mysql start
  • hive