centOS中安装hive

前端之家收集整理的这篇文章主要介绍了centOS中安装hive前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

本文主要介绍在centOS中安装hive。@H_404_5@@H_404_5@

1. 解压apache-hive-1.2.1-bin.zip@H_404_5@@H_404_5@

2.以hive-default.xml.template为模板,创建hive-site.xml@H_404_5@@H_404_5@

@H_404_5@@H_404_5@
cp hive-default.xml.template hive-site.xml

3.修改hive-site.xml@H_404_5@@H_404_5@

将${system:java.io.tmpdir}/${system:user.name}位置,修改自定义tmp目录(/usr/bigdata/apache-hive-1.2.1-bin/tmp)
@H_404_5@@H_404_5@

4.启动hive@H_404_5@@H_404_5@

进入bin目录,执行hive命令,./hive@H_404_5@
@H_404_5@@H_404_5@

5.如果报错java.lang.IncompatibleClassChangeError: Found class jline.Terminal,but interface was expected@H_404_5@

打开hadoop/etc/hadoop/hadoop-env.sh,增加export HADOOP_USER_CLASSPATH_FIRST=true
@H_404_5@

@H_404_5@

6.安装MysqL@H_404_5@

@H_404_5@
yum install MysqL-server

7.启动 MysqL 服务@H_404_5@

@H_404_5@
service MysqLd start

8.验证MysqL是否成功启动@H_404_5@

@H_404_5@
netstat -nplt |grep 3306

9.将MysqL-connector-java-5.1.39-bin.jar拷贝到apache-hive-1.2.1-bin/lib目录下@H_404_5@

10.MysqL中赋予用户权限@H_404_5@

@H_404_5@
grant all on *.* to root@'%' identified by '123456';

@H_404_5@

11.修改hive-site.xml,配置MysqL@H_404_5@

主要配置下面几项内容:@H_404_5@
@H_404_5@
  <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.ConnectionURL</name>
    <value>jdbc:MysqL://localhost/hive</value>
    <description>JDBC connect string 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>javax.jdo.option.ConnectionPassword</name>
    <value>123456</value>
    <description>password to use against Metastore database</description>
  </property>

@H_404_5@

12.再次启动hive(同步骤4)@H_404_5@

13.验证,进入MysqL的hive数据库,使用show tables,显示如下结果@H_404_5@


@H_404_5@

@H_404_5@

14.至此,hive安装成功。

猜你在找的CentOS相关文章