HIVE 安装指南

来源：互联网发布：ukec中介怎么样知乎编辑：程序博客网时间：2024/06/11 19:55

1、安装mysql 并配置库和用户

安装mysql详见我另一篇文章：http://blog.csdn.net/xiefu5hh/article/details/52191488

建立用户hive

并建立库 hive_meta

sht-sgmhadoopnn-01:mysqladmin:/usr/local/mysql:>mysql -uroot -p
mysql> create database hive_lmeta;
Query OK, 1 row affected (0.04 sec)

mysql> create user 'hive' identified by 'hive';
Query OK, 0 rows affected (0.05 sec)

mysql> grant all privileges on hive_meta.* to 'hive'@'%';
Query OK, 0 rows affected (0.03 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

2.安装HIVE

下载hive 并解压缩

设置用户环境变量：

export JAVA_HOME=/usr/java/jdk1.7.0_67-cloudera
export HADOOP_HOME=/hadoop/hadoop-2.7.2
export HADOOP_COMMON_LIB_NATIVE_DIR=$HADOOP_HOME/lib/native
export HADOOP_OPTS="-Djava.library.path=$HADOOP_HOME/lib"
export HBASE_HOME=/hadoop/hbase-1.2.0
export ZOOKEEPER_HOME=/hadoop/zookeeper
export HIVE_HOME=/hadoop/hive
export PATH=.:$HADOOP_HOME/bin:$JAVA_HOME/bin:$ZOOKEEPER_HOME/bin:$HBASE_HOME/bin:$HIVE_HOME/bin:$PATH

3.配置mysql connector

http://ftp.nchu.edu.tw/Unix/Database/MySQL/Downloads/Connector-J/mysql-connector-java-5.1.36.tar.gz

解压文件，将jar放入hive/lib中

4.配置HIVE的配置文件

vi hive/conf/hive_site.xml

    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>
     <property>
     <name>hive.metastore.warehouse.dir</name>
     <value>hdfs://master:9000/usr/hive/warehouse</value>
      </property>
     <property>
      <name>hive.exec.scratchdir</name>
        <value>hdfs://master:9000/usr/hive/warehouse</value>
       </property>
       <property>
           <name>hive.querylog.location</name>
           <value>/home/spark/hive/logs</value>
       </property>
       <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://node2:3306/hive_meta?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>hive</value>
     </property>
    <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>hive</value>
     </property>
     <property>
        <name>datanucleus.fixedDatastore</name>
        <value>false</value>
      </property>
</configuration>

5.初始化mysql的数据库

schematool -initSchema -dbType mysql

6.测试安装

hive

0 0