前置条件: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 morecontributor license agreements. See the NOTICE file distributed withthis 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 withthe License. You may obtain a copy of the License athttp://www.apache.org/licenses/LICENSE-2.0Unless required by applicable law or agreed to in writing, softwaredistributed 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 andlimitations 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>
~ 5.初始化
schematool -dbType mysql -initSchema --verbose
hive -version 或 hive 能够进入hive
