hadoop-企业版环境搭建(五)-安装Hive

本地derby和mysql模式的安装(远端模式的安装)

一、本地derby模式的安装

• 解压

tar -zxvf apache-hive-1.2.1-bin.tar.gz
[root@node1 software]# mv apache-hive-1.2.1-bin /home

• 清空配置文件，配置hive-site.xml文件

[root@node1 conf]# cp hive-default.xml.template hive-site.xml
[root@node1 conf]# vi hive-site.xml
<property>  
  <name>javax.jdo.option.ConnectionURL</name>  
  <value>jdbc:derby:;databaseName=metastore_db;create=true</value>  
</property>  
<property>  
  <name>javax.jdo.option.ConnectionDriverName</name>  
  <value>org.apache.derby.jdbc.EmbeddedDriver</value>  
</property>  
<property>  
  <name>hive.metastore.local</name>  
  <value>true</value>  
</property>  
<property>  
  <name>hive.metastore.warehouse.dir</name>  
  <value>/user/hive/warehouse</value>  
</property>  
##配置环境变量
export JAVA_HOME=/usr/java/jdk1.7.0_79
export  HBASE_HOME=/home/hbase-1.1.3
export HIVE_HOME=/home/apache-hive-1.2.1-bin
export PATH=$PATH:$JAVA_HOME/bin:$HBASE_HOME/bin:$HIVE_HOME/bin

• 启动hive

##出错：原因是版本的问题，
7/10/08 03:40:17 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

Logging initialized using configuration in jar:file:/home/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties
[ERROR] Terminal initialization failed; falling back to unsupported
java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected...
Exception in thread "main" java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected
    at jline.console.ConsoleReader.<init>


/home/hadoop-2.5.1/share/hadoop/httpfs/tomcat/webapps/webhdfs/WEB-INF/lib/
解决的方法：
[root@node1 apache-hive-1.2.1-bin]# find / -name jline*.jar
/home/hadoop-2.5.1/share/hadoop/yarn/lib/jline-0.9.94.jar
/home/apache-hive-1.2.1-bin/lib/jline-2.12.jar
/home/zookeeper-3.4.6/lib/jline-0.9.94.jar

解决方法：
修改HADOOP_HOME\lib目录下的jline-*.jar 变成HIVE_HOME\lib下的jline-2.12.jar。hadoop和hive版本一致
Hadoop jar包 路径是：share/hadoop/yarn/lib
启动 结果：

[root@node1 lib]# hive
17/10/08 04:30:14 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

Logging initialized using configuration in jar:file:/home/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties

hive> show tables;
OK
Time taken: 3.514 seconds

二、本地mysql模式的安装
1.mysql的安装参考链接
2.配置hive-site.xml文件

<configuration>
<property>  
  <name>hive.metastore.warehouse.dir</name>  
  <value>/user/hive_remote/warehouse</value>  
</property>  

<property>  
  <name>hive.metastore.local</name>  
  <value>true</value>  
</property>  

<property>  
  <name>javax.jdo.option.ConnectionURL</name>  
  <value>jdbc:mysql://192.168.146.100/hive_remote?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>123456</value>  
</property>  

</configuration>

3.将mysql-connector-java-5.1.32-bin.jar文件放置到/home/apache-hive-1.2.1-bin/lib下面

4.启动

[root@node1 ~]# hive
17/10/08 05:50:30 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist

Logging initialized using configuration in jar:file:/home/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties
hive> 

一些错误的问题可以参考
三、远端模式的安装（分remote一体和remote分开的）
参考:地址