<span style="background-color: rgb(255, 255, 255); font-family: Arial, Helvetica, sans-serif;"> 1. 解压缩apache-hive-1.2.1-bin.tar.gz 文件。</span>
tar -zxf apache-hive-1.2.1-bin.tar.gz //这里解压在/opt目录下
2. 配置Hive,进入进入/opt/apache-hive-1.2.1-bin/conf目录,将hive-env.sh.template复制为hive-env.sh,并在hive-env.sh中添加HADOOP_HOME路径。
3. 添加环境变量。在/etc/profile中添加hive的环境变量:
export HIVE_HOME=/opt/apache-hive-1.2.1-bin,export PATH=$HIVE_HOME/bin:$PATH
4. 登录Mysql,创建hive数据库,进入$HIVE_HOME/conf目录,新建 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://master:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.PersistenceManagerFactoryClass</name>
<value>org.datanucleus.api.jdo.JDOPersistenceManagerFactory</value>
</property>
<property>
<name>javax.jdo.option.DetachAllOnCommit</name>
<value>true</value>
</property>
<property>
<name>javax.jdo.option.NonTransactionalRead</name>
<value>true</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>javax.jdo.option.Multithreaded</name>
<value>true</value>
</property>
<property>
<name>datanucleus.connectionPoolingType</name>
<value>BoneCP</value>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>hive.server2.thrift.port</name>
<value>10000</value>
</property>
<property>
<name>hive.server2.thrift.bind.host</name>
<value>master</value>
</property>
<property><name>hive.hwi.listen.host</name><value>0.0.0.0</value></property>
<property><name>hive.hwi.listen.port</name><value>9999</value></property>
<property><name>hive.hwi.war.file</name><value>lib/hive-hwi-1.2.1.war</value></property>
</configuration>
5. 上传mysql驱动mysql-connector-java-5.1.25-bin.jar到$HIVE_HOME/lib目录。
6. 重命名 $HADOOP_HOME/share/hadoop/yarn/lib/jline-0.9.94.jar 为jline-0.9.94.jar.bak。
7. 将Hive下的jline包拷贝到Hadoop下:
cp $HIVE_HOME/lib/jline-2.12.jar $HADOOP_HOME/share/hadoop/yarn/lib/
以上即为hive的配置过程,在终端输入hive即可进入CLI模式。