Hive安装教程

前置条件:hadoop&mysql

docker容器安装mysql-CSDN博客

以下的/opt/bigdata目录根据自己实际情况更改

1.上传hive包并解压

tar -zxvf apache-hive-3.1.3-bin.tar.gz -C /opt/bigdata/

2.修改路径

mv /opt/bigdata/apache-hive-3.1.3-bin/ hive

cd /opt/bigdata/hive/lib/

上传mysql连接驱动jar包到hive的lib目录

3.将hive下的bin目录加入到/etc/profile中

export  HIVE_HOME=/opt/bigdata/hive/
export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$ZOOKEEPER_HOME/bin:$ZOOKEEPER_HOME/conf:$HIVE_HOME/bin

source /etc/profile 使环境变量生效

4.配置HIVE

cd /opt/bigdata/hive/conf/
cp hive-default.xml.template hive-site.xml

vim hive-site.xml

【行数】 dd 删除所有内容

添加以下mysql数据库连接信息,根据自己的数据库连接信息修改用户名密码以及数据库名字和端口

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?><!--
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to You under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
-->
<configuration>
  <property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
  </property>
  <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value>123456</value>
   </property>
   <property>
        <name>javax.jdo.option.ConnectionURL</name>mysql
        <value>jdbc:mysql://ly01:3306/ly01?createDatabaseIfNotExist=true</value>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionDriverName</name>mysql
        <value>com.mysql.jdbc.Driver</value>
    </property>

</configuration>
~