hive 安装

下载地址：dlcdn.apache.org/hive/hive-1…

解压：

[root@iZ2zebkqy02hia7o7gj8paZ files]# mkdir /usr/local/src/hive/
[root@iZ2zebkqy02hia7o7gj8paZ files]# tar -zxf apache-hive-1.2.2-bin.tar.gz -C /usr/local/src/hive/

配置环境变量：

[root@iZ2zebkqy02hia7o7gj8paZ files]# vim /etc/profile
export HIVE_HOME=/usr/local/src/hive/apache-hive-1.2.2-bin/
export PATH=$HIVE_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$JAVA_HOME/bin:/usr/local/nginx/sbin:/usr/local/php/bin:/usr/local/mysql/bin:$PATH

生效：

[root@iZ2zebkqy02hia7o7gj8paZ files]# source /etc/profile

编写配置文件:

[root@iZ2zebkqy02hia7o7gj8paZ conf]# mv hive-env.sh.template hive-env.sh
[root@iZ2zebkqy02hia7o7gj8paZ conf]# mv hive-default.xml.template hive-default.xml

修改hadoop-env.sh

export HADOOP_CLASSPATH=.$CLASSPATH:$HADOOP_CLASSPATH:$HODOOP_HOME/bin$f

编写/usr/local/src/hive/apache-hive-1.2.2-bin/bin/hive-config.sh

在文末添加：

export JAVA_HOME=/usr/local/src/java/jdk1.8.0_311/
export HADOOP_HOME=/usr/local/src/hadoop/hadoop-2.6.1
export HIVE_HOME=/usr/local/src/hive/apache-hive-1.2.2-bin/

创建临时文件夹

mkdir -p /tmp/hive/tmp

创建 hive-site.xml文件，cp hive-default.xml hive-site.xml

  <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://localhost:3306/hive</value>
    <description>JDBC connect string for a JDBC metastore</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.ConnectionPassword</name>
    <value>hive</value>
    <description>password to use against metastore database</description>
  </property>
  <property>
    <name>hive.hwi.listen.port</name>
    <value>3306</value>
    <description>This is the port the Hive Web Interface will listen on</description>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>hive</value>
    <description>Username to use against metastore database</description>
  </property>
  <property>
    <name>hive.exec.local.scratchdir</name>
    <value>tmp/hive/tmp</value>
    <description>Local scratch space for Hive jobs</description>
  </property>
  <property>
    <name>hive.downloaded.resources.dir</name>
    <value>/tmp/hive/tmp</value>
    <description>Temporary local directory for added resources in the remote file system.</description>
  </property>
  <property>
    <name>hive.querylog.location</name>
    <value>/tmp/hive/tmp</value>
    <description>Location of Hive run time structured log file</description>
  </property>

登录本地数据库：

创建hive数据库：

-- 这个hive数据库与hive-site.xml中localhost:3306/hive的hive对应，用来保存hive元数据
create database hive;

赋予权限

MySQL [(none)]> create user 'hive' identified by 'hive';
Query OK, 0 rows affected (0.00 sec)

MySQL [(none)]> grant all privileges on *.* to 'hive'@'localhost' identified by 'hive';
Query OK, 0 rows affected, 2 warnings (0.00 sec)

flush privileges;