Hive安装

最新推荐文章于 2024-02-28 16:40:51 发布

原创最新推荐文章于 2024-02-28 16:40:51 发布 · 256 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#hive #hadoop #大数据

本文详细介绍了Hive的安装步骤，包括解压安装包、配置环境变量、修改设置及初始化元数据等关键过程。同时，针对hive启动时可能出现的错误提供了具体的解决方案。

1.解压安装包

安装包下载地址：http://archive.apache.org/dist/hive/

tar -zxvf /opt/software/apache-hive-1.1.0-bin.tar.gz -C /usr/local/src
mv /usr/local/src/apache-hive-1.1.0-bin /usr/local/src/hive

2.配置环境变量

#hive
export HIVE_HOME=/usr/local/src/hive
export PATH=$PATH:$HIVE_HOME/bin

3.修改设置

cd $HIVE_HOME/conf

mv  hive-default.xml.template hive-site.xml

vi  hive-site.xml

修改以下设置

①数据库连接

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hbase01:3306/hive?createDatabaseIfNotExist=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;useSSL=false</value>
</property>

②数据库密码

<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
<description>password to use against metastore database</description>
</property>

③

<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
<description>
      Enforce metastore schema version consistency.
      True: Verify that version information stored in is compatible with one from Hive jars.  Also disable automatic
  False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.
</description>
</property>

④数据库驱动

<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>

⑤数据库用户

<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>Username to use against metastore database</description>
</property>

⑥在配置文件最上方新增下面两项,并根据实际情况进行修改

<property>
    <name>system:java.io.tmpdir</name>
    <value>/usr/local/src/hive/tmp</value>
    <description/>
 </property>
 <property>
    <name>system:user.name</name>
    <value>hive</value>
    <description/>
 </property>

4.初始化元数据

初始化之前需要先将数据库驱动拷贝到Hive安装目录的lib下

cp  /opt/software/mysql-connector-java-5.1.47.jar  $HIVE_HOME/lib

 ./schematool -initSchema -dbType mysql

初始化完成以后，Hive就安装好了~~~~

注:

hive启动报错：Found class jline.Terminal, but interface was expected

原因：
hadoop目录下存在老版本jline：
需要

cp $HIVE_HOME/lib/jline-2.12.jar  $HADOOP_HOME/share/hadoop/yarn/lib/

删除老版本的jline包

rm /usr/local/src/hadoop-2.6.0/share/hadoop/yarn/lib/jline-0.9.94.jar