hive3.1.1基于hadoop3.1.1安装

Mysql创建数据库

root登录mysql执行

use mysql;

CREATE USER 'hive'@'%' IDENTIFIED BY '123456';

Grant all privileges on *.* to 'hive'@'%' identified by '*******' with grant option;
flush privileges; 

hive 用户登录mysql执行 

create database logSave

配置hive配置文件

在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.local</name>
                 <value>true</value>
        </property>
        <property>
                <name>hive.metastore.client.socket.timeou