Hive配置

https://www.bilibili.com/video/BV1WY4y197g7?spm_id_from=333.788.player.switch&vd_source=531ef0571bd21a6f140383bcf2e73ef8&p=48

跟教程来，但有点问题
首先是使用centos的源不能下载mysql，需要更换数据源 ，手动更换
vi /etc/yum.repos.d/CentOS-Base.repo

`[base]
name=CentOS-$releasever - Base - mirrors.aliyun.com
failovermethod=priority
baseurl=http://mirrors.aliyun.com/centos/$releasever/os/$basearch/
http://mirrors.aliyuncs.com/centos/$releasever/os/$basearch/
http://mirrors.cloud.aliyuncs.com/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=http://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7

[updates]
name=CentOS-$releasever - Updates - mirrors.aliyun.com
failovermethod=priority
baseurl=http://mirrors.aliyun.com/centos/$releasever/updates/$basearch/
http://mirrors.aliyuncs.com/centos/$releasever/updates/$basearch/
http://mirrors.cloud.aliyuncs.com/centos/$releasever/updates/$basearch/
gpgcheck=1
gpgkey=http://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7

[extras]
name=CentOS-$releasever - Extras - mirrors.aliyun.com
failovermethod=priority
baseurl=http://mirrors.aliyun.com/centos/$releasever/extras/$basearch/
http://mirrors.aliyuncs.com/centos/$releasever/extras/$basearch/
http://mirrors.cloud.aliyuncs.com/centos/$releasever/extras/$basearch/
gpgcheck=1
gpgkey=http://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7`

然后是版本适配的问题
JDK是8 一开始我mysql下载的是5.1的一个版本 hive在官网没有找到教程里推荐的3.1 用的4.1

但是跟着教程在hive数据库表格初始化的时候会报错 提示“Exception in thread "main" java.lang.UnsupportedClassVersionError:
org/apache/hive/beeline/schematool/HiveSchemaTool has been compiled by a more recent version of the Java Runtime (class file version 61.0),
this version of the Java Runtime only recognizes class file versions up to 52.0”
你安装的 Hive 4.1.0 是用 Java 17（class file version 61.0）编译的
但你当前系统使用的 Java 版本太低（只能识别到 class file version 52.0，对应 Java 8）
jdk早就配好了，更改太麻烦了

最终解决办法 MySQL5.1.47 hive3.1.3（华为镜像云，官网没有）mysql-connector-java-5.1.47 jdk8
https://mirrors.huaweicloud.com/apache/hive/hive-3.1.3/

简单体验了一下 使用基本和mysql相差不多 但区别就是是使用sql语句执行mapreduce语句，感觉耗时很长

后续应该会在客户端使用
不然启动服务太麻烦了