大家好，我是本文的作者陈惜时，我将会在这篇文章中讲解一下在Centos7上安装Mysql过程。
前言
首先给大家简单粗暴的解释一下元数据是什么？
答：对主体信息的补充说明和描述。包括表的名称、列、分区及其属性，表的树所在的目录等，就像/home/softwares/hive/data...
1.上传、解压和安装我们的mysql文件
简单粗暴的进入我们的[root@bigdata01~]# cd /home/softwares/，之后使用命令rz上传我们的mysql5.7。
解压（注意使用-xvf解压）：
然后出现了很多后缀为rpm文件，所以我们使用rpm方式来安装。
现在来讲一个小故事，我们都知道Centos7开始自带Mariadb数据库，Mariadb属于开发者团队，但是Mysql被Oracle收购了，它担心突然有一天Oracle突然不开源了，Mysql突然收费了怎么办。。。。但开发者原来的目的就是想一直开源，所以它就保留了和Mysql一模一样的配置，然后它自己就开发了Mariadb，相当于Mysql的双胞胎姐妹。所以我们解压完成之后，就要卸载自带的Mariadb。
使用命令rpm -qa |grep mariadb查看所带的mariadb,卸载使用命令rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
卸载完毕后，就可以安装啦。
安装命令如下（记得要联网！）：
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
安装完毕：
2.初始化数据库
使用命令mysqld --initialize --user=mysql开始初始化：
初始化完毕之后，mysqld就开始启动了。
先 cat /var/log/mysqld.log |grep password看看我们数据库的密码是什么，最后：后面的就是密码。
面对那么难的密码，第一件事就是要修改它。
开始启动mysql，命令start mysqld.service和start mysqld.service
登录到我们的mysql然后开始修改密码（我修改成root）：
之后开始重启登录（顺便看看我们里面有啥，我顺便建了一个test_nmu的数据库）：
开始连接建库（我建了一个student的表）：
如果连接不上数据库，试试在那个黑黑的窗口执行以下命令：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'bigdata01' IDENTIFIED BY 'root' WITH GRANT OPTION；
create user 'root'@'%' identified by 'root'；
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
3.配置Hive：
这是我电脑里面的jar文件，如果没有的话记得上传。
使用notepad++修改我们的hive-site.xml文件
（把之前的全删掉）修改内容如下：
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://bigdata01:3306/hivehive?createDatabaseIfNotExist=true&characterEncoding=utf-8&useSSL=false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
</property>
</configuration>
效果图（我是root用户）：
开启Hadoop集群：
开始初始化，敲入我们的初始化命令
bin/schematool -initSchema -dbType mysql
成功初始化：
之后可以使用hive命令为所欲为啦
到此，Centos7的mysql已安装完毕。
最后附上我所有运行的过程：
Copyright (c) 2002-2015 NetSarang Computer, Inc. All rights reserved.
Type `help' to learn how to use Xshell prompt.
[c:\~]$
Connecting to 192.168.26.100:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
Last login: Mon Oct 3 12:52:45 2022
[root@bigdata01 ~]# cd /home/softwares/
[root@bigdata01 softwares]# rz
[root@bigdata01 softwares]# rz
[root@bigdata01 softwares]# ls
hadoop hive jdk mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar zookeeper
[root@bigdata01 softwares]# tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
mysql-community-libs-5.7.22-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-5.7.22-1.el7.x86_64.rpm
mysql-community-test-5.7.22-1.el7.x86_64.rpm
mysql-community-server-5.7.22-1.el7.x86_64.rpm
mysql-community-client-5.7.22-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
mysql-community-devel-5.7.22-1.el7.x86_64.rpm
mysql-community-common-5.7.22-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm
[root@bigdata01 softwares]# ls
hadoop mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
hive mysql-community-libs-5.7.22-1.el7.x86_64.rpm
jdk mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
mysql-community-client-5.7.22-1.el7.x86_64.rpm mysql-community-server-5.7.22-1.el7.x86_64.rpm
mysql-community-common-5.7.22-1.el7.x86_64.rpm mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
mysql-community-devel-5.7.22-1.el7.x86_64.rpm mysql-community-test-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-5.7.22-1.el7.x86_64.rpm zookeeper
mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm
[root@bigdata01 softwares]# rpm -qa |grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64
[root@bigdata01 softwares]# rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
[root@bigdata01 softwares]# ls
hadoop mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
hive mysql-community-libs-5.7.22-1.el7.x86_64.rpm
jdk mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
mysql-community-client-5.7.22-1.el7.x86_64.rpm mysql-community-server-5.7.22-1.el7.x86_64.rpm
mysql-community-common-5.7.22-1.el7.x86_64.rpm mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
mysql-community-devel-5.7.22-1.el7.x86_64.rpm mysql-community-test-5.7.22-1.el7.x86_64.rpm
mysql-community-embedded-5.7.22-1.el7.x86_64.rpm zookeeper
mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm
[root@bigdata01 softwares]# rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
警告：mysql-community-common-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中... ################################# [100%]
正在升级/安装...
1:mysql-community-common-5.7.22-1.e################################# [100%]
[root@bigdata01 softwares]# rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
警告：mysql-community-libs-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中... ################################# [100%]
正在升级/安装...
1:mysql-community-libs-5.7.22-1.el7################################# [100%]
[root@bigdata01 softwares]# rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
警告：mysql-community-client-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中... ################################# [100%]
正在升级/安装...
1:mysql-community-client-5.7.22-1.e################################# [100%]
[root@bigdata01 softwares]# rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
警告：mysql-community-server-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中... ################################# [100%]
正在升级/安装...
1:mysql-community-server-5.7.22-1.e################################# [100%]
[root@bigdata01 softwares]# mysqld --initialize --user=mysql
[root@bigdata01 softwares]# cat /var/log/mysqld.log |grep password
2022-10-03T05:28:06.861108Z 1 [Note] A temporary password is generated for root@localhost: &,Pg!;ude91d
[root@bigdata01 softwares]# service mysqld.start
The service command supports only basic LSB actions (start, stop, restart, try-restart, reload, force-reload, status). For other actions, please try to use systemctl.
[root@bigdata01 softwares]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@bigdata01 softwares]# jps
11797 Jps
[root@bigdata01 softwares]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> alter user 'root'@'localhost' identified by 'root';
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
Bye
[root@bigdata01 softwares]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.22 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database 'test_nmu' character set utf8_general_ci;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''test_nmu' character set utf8_general_ci' at line 1
mysql> create database 'test_nmu';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''test_nmu'' at line 1
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> create database test_nmu;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test_nmu |
+--------------------+
5 rows in set (0.00 sec)
mysql> use test_nmu;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'bigdata01' IDENTIFIED BY 'root' WITH GRANT OPTION
-> ;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> create user 'root'@'%' identified by 'root'
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test_nmu |
+--------------------+
5 rows in set (0.00 sec)
mysql> use test_nmu;
Database changed
mysql> show tables;
+--------------------+
| Tables_in_test_nmu |
+--------------------+
| student |
+--------------------+
1 row in set (0.00 sec)
mysql> select * from student;
+----+------+------+
| id | name | age |
+----+------+------+
| 1 | nmu | 30 |
| 2 | test | 20 |
+----+------+------+
2 rows in set (0.00 sec)
mysql> exit;
Bye
[root@bigdata01 softwares]# cd hive
[root@bigdata01 hive]# ls
bin binary-package-licenses conf examples hcatalog jdbc lib LICENSE NOTICE RELEASE_NOTES.txt scratchdir scripts
[root@bigdata01 hive]# cd lib
[root@bigdata01 lib]# ls
accumulo-core-1.7.3.jar jackson-dataformat-smile-2.12.0.jar
accumulo-fate-1.7.3.jar jackson-mapper-asl-1.9.13.jar
accumulo-start-1.7.3.jar jackson-module-scala_2.11-2.12.0.jar
accumulo-trace-1.7.3.jar jamon-runtime-2.3.1.jar
aircompressor-0.10.jar janino-2.7.6.jar
ant-1.9.1.jar JavaEWAH-0.3.2.jar
ant-launcher-1.9.1.jar javassist-3.20.0-GA.jar
antlr4-runtime-4.5.jar javax.annotation-api-1.2.jar
antlr-runtime-3.5.2.jar javax.inject-2.5.0-b32.jar
aopalliance-repackaged-2.5.0-b32.jar javax.jdo-3.2.0-m3.jar
apache-curator-2.12.0.pom javax.servlet-api-3.1.0.jar
apache-jsp-9.3.20.v20170531.jar javax.servlet.jsp-2.3.2.jar
apache-jstl-9.3.20.v20170531.jar javax.servlet.jsp-api-2.3.1.jar
arrow-format-0.8.0.jar javax.ws.rs-api-2.0.1.jar
arrow-memory-0.8.0.jar javolution-5.5.1.jar
arrow-vector-0.8.0.jar jaxb-api-2.2.11.jar
asm-5.0.1.jar jcodings-1.0.18.jar
asm-commons-5.0.1.jar jcommander-1.32.jar
asm-tree-5.0.1.jar jdo-api-3.0.1.jar
audience-annotations-0.5.0.jar jersey-client-2.25.1.jar
avatica-1.11.0.jar jersey-common-2.25.1.jar
avro-1.8.2.jar jersey-container-servlet-core-2.25.1.jar
avro-ipc-1.8.2.jar jersey-guava-2.25.1.jar
avro-mapred-1.8.2-hadoop2.jar jersey-media-jaxb-2.25.1.jar
bonecp-0.8.0.RELEASE.jar jersey-server-2.25.1.jar
calcite-core-1.16.0.jar jettison-1.1.jar
calcite-druid-1.16.0.jar jetty-annotations-9.3.20.v20170531.jar
calcite-linq4j-1.16.0.jar jetty-client-9.3.20.v20170531.jar
chill_2.11-0.8.4.jar jetty-http-9.3.20.v20170531.jar
chill-java-0.8.4.jar jetty-io-9.3.20.v20170531.jar
commons-cli-1.2.jar jetty-jaas-9.3.20.v20170531.jar
commons-codec-1.15.jar jetty-jndi-9.3.20.v20170531.jar
commons-collections4-4.1.jar jetty-plus-9.3.20.v20170531.jar
commons-compiler-2.7.6.jar jetty-rewrite-9.3.20.v20170531.jar
commons-compress-1.19.jar jetty-runner-9.3.20.v20170531.jar
commons-crypto-1.0.0.jar jetty-schemas-3.1.jar
commons-dbcp-1.4.jar jetty-security-9.3.20.v20170531.jar
commons-io-2.6.jar jetty-server-9.3.20.v20170531.jar
commons-lang-2.6.jar jetty-servlet-9.3.20.v20170531.jar
commons-lang3-3.9.jar jetty-util-9.3.20.v20170531.jar
commons-logging-1.0.4.jar jetty-webapp-9.3.20.v20170531.jar
commons-math-2.1.jar jetty-xml-9.3.20.v20170531.jar
commons-math3-3.6.1.jar jline-2.12.jar
commons-pool-1.5.4.jar joda-time-2.9.9.jar
commons-vfs2-2.1.jar jodd-core-3.5.2.jar
compress-lzf-1.0.3.jar joni-2.1.11.jar
curator-client-2.12.0.jar jpam-1.1.jar
curator-framework-2.12.0.jar json-1.8.jar
curator-recipes-2.12.0.jar json4s-ast_2.11-3.2.11.jar
datanucleus-api-jdo-4.2.4.jar json4s-core_2.11-3.2.11.jar
datanucleus-core-4.1.17.jar json4s-jackson_2.11-3.2.11.jar
datanucleus-rdbms-4.1.19.jar jsr305-3.0.0.jar
derby-10.14.1.0.jar jta-1.1.jar
disruptor-3.3.6.jar kryo-shaded-3.0.3.jar
dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar libfb303-0.9.3.jar
druid-hdfs-storage-0.12.0.jar libthrift-0.9.3.jar
ecj-4.4.2.jar log4j-1.2-api-2.17.1.jar
esri-geometry-api-2.0.0.jar log4j-api-2.17.1.jar
findbugs-annotations-1.3.9-1.jar log4j-core-2.17.1.jar
flatbuffers-1.2.0-3f79e055.jar log4j-slf4j-impl-2.17.1.jar
groovy-all-2.4.11.jar log4j-web-2.17.1.jar
gson-2.2.4.jar lz4-java-1.4.0.jar
guava-19.0.jar memory-0.9.0.jar
hbase-client-2.0.0-alpha4.jar metrics-core-3.1.0.jar
hbase-common-2.0.0-alpha4.jar metrics-graphite-3.1.5.jar
hbase-common-2.0.0-alpha4-tests.jar metrics-json-3.1.0.jar
hbase-hadoop2-compat-2.0.0-alpha4.jar metrics-jvm-3.1.0.jar
hbase-hadoop2-compat-2.0.0-alpha4-tests.jar minlog-1.3.0.jar
hbase-hadoop-compat-2.0.0-alpha4.jar mysql-connector-java-5.1.46-bin.jar
hbase-http-2.0.0-alpha4.jar mysql-connector-java-5.1.46.jar
hbase-mapreduce-2.0.0-alpha4.jar mysql-metadata-storage-0.12.0.jar
hbase-metrics-2.0.0-alpha4.jar netty-3.10.5.Final.jar
hbase-metrics-api-2.0.0-alpha4.jar netty-all-4.1.17.Final.jar
hbase-prefix-tree-2.0.0-alpha4.jar netty-buffer-4.1.17.Final.jar
hbase-procedure-2.0.0-alpha4.jar netty-common-4.1.17.Final.jar
hbase-protocol-2.0.0-alpha4.jar objenesis-2.1.jar
hbase-protocol-shaded-2.0.0-alpha4.jar opencsv-2.3.jar
hbase-replication-2.0.0-alpha4.jar opencsv-3.9.jar
hbase-server-2.0.0-alpha4.jar orc-core-1.5.8.jar
hbase-shaded-miscellaneous-1.0.1.jar orc-shims-1.5.8.jar
hbase-shaded-netty-1.0.1.jar orc-tools-1.5.8.jar
hbase-shaded-protobuf-1.0.1.jar org.abego.treelayout.core-1.0.1.jar
HikariCP-2.6.1.jar osgi-resource-locator-1.0.1.jar
hive-accumulo-handler-3.1.3.jar paranamer-2.7.jar
hive-beeline-3.1.3.jar parquet-hadoop-bundle-1.10.0.jar
hive-classification-3.1.3.jar php
hive-cli-3.1.3.jar postgresql-9.4.1208.jre7.jar
hive-common-3.1.3.jar postgresql-metadata-storage-0.12.0.jar
hive-contrib-3.1.3.jar protobuf-java-2.5.0.jar
hive-druid-handler-3.1.3.jar py
hive-exec-3.1.3.jar py4j-0.10.6.jar
hive-hbase-handler-3.1.3.jar pyrolite-4.13.jar
hive-hcatalog-core-3.1.3.jar RoaringBitmap-0.5.11.jar
hive-hcatalog-server-extensions-3.1.3.jar scala-compiler-2.11.0.jar
hive-hplsql-3.1.3.jar scala-library-2.11.8.jar
hive-jdbc-3.1.3.jar scalap-2.11.0.jar
hive-jdbc-handler-3.1.3.jar scala-parser-combinators_2.11-1.0.1.jar
hive-kryo-registrator-3.1.3.jar scala-reflect-2.11.0.jar
hive-llap-client-3.1.3.jar scala-xml_2.11-1.0.1.jar
hive-llap-common-3.1.3.jar sketches-core-0.9.0.jar
hive-llap-common-3.1.3-tests.jar snappy-java-1.1.4.jar
hive-llap-ext-client-3.1.3.jar spark-core_2.11-2.3.0.jar
hive-llap-server-3.1.3.jar spark-kvstore_2.11-2.3.0.jar
hive-llap-tez-3.1.3.jar spark-launcher_2.11-2.3.0.jar
hive-metastore-3.1.3.jar spark-network-common_2.11-2.3.0.jar
hive-serde-3.1.3.jar spark-network-shuffle_2.11-2.3.0.jar
hive-service-3.1.3.jar spark-tags_2.11-2.3.0.jar
hive-service-rpc-3.1.3.jar spark-unsafe_2.11-2.3.0.jar
hive-shims-0.23-3.1.3.jar sqlline-1.3.0.jar
hive-shims-3.1.3.jar ST4-4.0.4.jar
hive-shims-common-3.1.3.jar stax-api-1.0.1.jar
hive-shims-scheduler-3.1.3.jar stream-2.7.0.jar
hive-spark-client-3.1.3.jar super-csv-2.2.0.jar
hive-standalone-metastore-3.1.3.jar taglibs-standard-impl-1.2.5.jar
hive-storage-api-2.7.0.jar taglibs-standard-spec-1.2.5.jar
hive-streaming-3.1.3.jar tempus-fugit-1.1.jar
hive-testutils-3.1.3.jar threetenbp-1.3.5.jar
hive-upgrade-acid-3.1.3.jar transaction-api-1.1.jar
hive-vector-code-gen-3.1.3.jar unused-1.0.0.jar
hk2-api-2.5.0-b32.jar validation-api-1.1.0.Final.jar
hk2-locator-2.5.0-b32.jar velocity-1.7.jar
hk2-utils-2.5.0-b32.jar websocket-api-9.3.20.v20170531.jar
hppc-0.7.2.jar websocket-client-9.3.20.v20170531.jar
htrace-core-3.2.0-incubating.jar websocket-common-9.3.20.v20170531.jar
httpclient-4.5.13.jar websocket-server-9.3.20.v20170531.jar
httpcore-4.4.13.jar websocket-servlet-9.3.20.v20170531.jar
ivy-2.4.0.jar xbean-asm5-shaded-4.4.jar
jackson-annotations-2.12.0.jar xz-1.5.jar
jackson-core-2.12.0.jar zookeeper-3.4.6.jar
jackson-core-asl-1.9.13.jar zstd-jni-1.3.2-2.jar
jackson-databind-2.12.0.jar
[root@bigdata01 lib]# cd /home/softwares/hive/
[root@bigdata01 hive]# jps
12233 Jps
[root@bigdata01 hive]# start-all.sh
Starting namenodes on [bigdata01]
上一次登录：一 10月 3 12:53:30 CST 2022从 192.168.26.1pts/0 上
Starting datanodes
上一次登录：一 10月 3 14:16:44 CST 2022pts/0 上
Starting secondary namenodes [bigdata01]
上一次登录：一 10月 3 14:16:47 CST 2022pts/0 上
Starting resourcemanager
上一次登录：一 10月 3 14:16:50 CST 2022pts/0 上
Starting nodemanagers
上一次登录：一 10月 3 14:16:54 CST 2022pts/0 上
[root@bigdata01 hive]# jps
13336 Jps
13003 ResourceManager
12734 SecondaryNameNode
12447 NameNode
[root@bigdata01 hive]# bin/schematool -initSchema -dbType mysql
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/softwares/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/softwares/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL: jdbc:mysql://bigdata01:3306/hivehive?createDatabaseIfNotExist=true&characterEncoding=utf-8&useSSL=false
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: root
Starting metastore schema initialization to 3.1.0
Initialization script hive-schema-3.1.0.mysql.sql
Initialization script completed
schemaTool completed
[root@bigdata01 hive]# hive
which: no hbase in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/home/softwares/jdk/bin:/home/softwares/jdk/jre/bin:/home/softwares/hadoop/sbin:/home/softwares/hadoop/bin:/home/softwares/zookeeper/bin:/home/softwares/hive/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/softwares/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/softwares/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Hive Session ID = fa1f4c37-ccd8-4659-a80c-ef59d1cffb6c
Logging initialized using configuration in jar:file:/home/softwares/hive/lib/hive-common-3.1.3.jar!/hive-log4j2.properties Async: true
Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Hive Session ID = c307e1ca-deab-41e7-a9fe-506f299244e6
hive> show databases;
OK
default
Time taken: 0.562 seconds, Fetched: 1 row(s)
hive> create table t_test(id int,name string);
OK
Time taken: 0.556 seconds
hive> show tables;
OK
t_test
Time taken: 0.08 seconds, Fetched: 1 row(s)
hive> insert into t_test(id,name) values(1,'zhangsan');
Query ID = root_20221003142741_7ccb7835-4dbd-4588-9250-9dcd926165e5
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
set mapreduce.job.reduces=<number>
Starting Job = job_1664777817756_0001, Tracking URL = http://bigdata01:8088/proxy/application_1664777817756_0001/
Kill Command = /home/softwares/hadoop/bin/mapred job -kill job_1664777817756_0001
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
2022-10-03 14:28:02,017 Stage-1 map = 0%, reduce = 0%
2022-10-03 14:28:17,516 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 3.38 sec
2022-10-03 14:28:25,745 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 5.17 sec
MapReduce Total cumulative CPU time: 5 seconds 170 msec
Ended Job = job_1664777817756_0001
Stage-4 is selected by condition resolver.
Stage-3 is filtered out by condition resolver.
Stage-5 is filtered out by condition resolver.
Moving data to directory hdfs://bigdata01:9000/user/hive/warehouse/t_test/.hive-staging_hive_2022-10-03_14-27-41_095_3829419200530242794-1/-ext-10000
Loading data to table default.t_test
MapReduce Jobs Launched:
Stage-Stage-1: Map: 1 Reduce: 1 Cumulative CPU: 5.17 sec HDFS Read: 15264 HDFS Write: 244 SUCCESS
Total MapReduce CPU Time Spent: 5 seconds 170 msec
OK
Time taken: 47.328 seconds
hive>
