hive-1.2.1的安装步骤

本篇内容主要讲解"hive-1.2.1的安装步骤"，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习"hive-1.2.1的安装步骤"吧!

环境介绍

mysql配置

新建用户hive，密码hive，然后授权。数据库IP：192.168.2.11 端口：3306

CREATE USER 'hive'@'%' IDENTIFIED BY 'hive';GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%' WITH GRANT OPTION;FLUSH PRIVILEGES;CREATE DATABASE hive;alter database hive character set latin1;

Hive配置

解压hive-1.2.1到/home/hadoop/work/hive-1.2.1目录下，然后修改配置文件

修改hive-site.xml，进入hive的conf目录下

[hadoop@bi13 conf]$ mv hive-env.sh.template hive-site.xml[hadoop@bi13 conf]$ vim hive-site.xml

hive-site.xml，参数说明：

  hive.metastore.warehouse.dir  hdfs://masters/user/hive/warehouse  location of default database for the warehouse  hive.metastore.uris  thrift://bi10:9083,thrift://bi12:9083  Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.  hive.exec.scratchdir  hdfs://masters/user/hive/tmp  HDFS root scratch dir for Hive jobs which gets created with write all (733) permission. For each connecting user, an HDFS scratch dir: ${hive.exec.scratchdir}/<username> is created, with ${hive.scratch.dir.permission}.  javax.jdo.option.ConnectionPassword  hive  password to use against metastore database    javax.jdo.option.ConnectionDriverName  com.mysql.jdbc.Driver  Driver class name for a JDBC metastore    javax.jdo.option.ConnectionURL  jdbc:mysql://192.168.2.11:3306/hive?createDatabaseIfNotExist=true  JDBC connect string for a JDBC metastore    javax.jdo.option.ConnectionUserName  hive  Username to use against metastore database  hive.querylog.location  /home/hadoop/work/hive-1.2.1/tmp/iotmp  Location of Hive run time structured log file    hive.server2.logging.operation.log.location  /home/hadoop/work/hive-1.2.1/tmp/operation_logs  Top level directory where operation logs are stored if logging functionality is enabled  hive.exec.local.scratchdir  /home/hadoop/work/hive-1.2.1/tmp/${system:user.name}  Local scratch space for Hive jobs  hive.downloaded.resources.dir  /home/hadoop/work/hive-1.2.1/tmp/${hive.session.id}_resources  Temporary local directory for added resources in the remote file system.

使用hive下面的jline-2.12.jar替代hadoop下面的jline-0.9.94.jar

mv hive-1.2.1/lib/jline-2.12.jar hadoop-2.6.2/share/hadoop/yarn/lib/mv hadoop-2.6.2/share/hadoop/yarn/lib/jline-0.9.94.jar hadoop-2.6.2/share/hadoop/yarn/lib/jline-0.9.94.jar.bak

把以上操作复制到所有部署hive的机器上

启动metastore service

分别在bi10和bi12下面启动metastore service

nohup hive --service metastore > null 2>&1 &

测试

进入hive，看是否有问题。如果存在问题是用hive --hiveconf hive.root.logger=DEBUG,console启动，可以看到具体的日志。

[hadoop@bi13 work]$ hiveSLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/home/hadoop/work/hadoop-2.6.2/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/home/hadoop/work/spark-1.5.1/lib/spark-assembly-1.5.1-hadoop2.4.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/home/hadoop/work/hadoop-2.6.2/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/home/hadoop/work/spark-1.5.1/lib/spark-assembly-1.5.1-hadoop2.4.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]Logging initialized using configuration in jar:file:/home/hadoop/work/hive-1.2.1/lib/hive-common-1.2.1.jar!/hive-log4j.propertieshive>

到此，相信大家对"hive-1.2.1的安装步骤"有了更深的了解，不妨来实际操作一番吧！这里是网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！