这是我出现的错误，最开始是图二，在我的不断尝试下变成图一，在变成图二，而且没有提示
出错了在博客上搜索是我的思路之一，网上的解决办法有改权限，有重置密码，这些我的都没有问题，
由于不断的试错，越来越没有思路，请教了老师
第一步先检查一下hdfs和yarn是否正常（jps查看下，我的确实都没了）
第二步 mysql数据库是否正常（这一步我开始是sudo service mysql restart ）
如果都好着的话，
第三步把hive-site.xml的参数检查一下
（当时我检查了不下10次，最后连大小写都没有放过）
第四步 再次尝试初始化，失败（应该是这里我出现了图二错误 #不太确定）
接着我进行了 如下操作
mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, 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> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| hive |
| mysql |
| performance_schema |
| test |
+——————–+
5 rows in set (0.02 sec)
mysql> grant all privileges on . to ‘hive’@’% ‘ identified by ‘hive’ with grant option;
Query OK, 0 rows affected (0.02 sec)
mysql>flush privileges;（不能忘记这步）
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
[hadoop@hadoop1 ~]$ sudo mysql -u hive -p -h hadoop1（不知道这一步是不是成功重点我还太菜）
[sudo] password for hadoop:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, 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> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| hive |
| mysql |
| performance_schema |
| test |
+——————–+
5 rows in set (0.00 sec)
接着重新初始化 OK 了 如图（耗费一下午成功了）
Original: https://blog.csdn.net/weixin_50393358/article/details/125747980
Author: 梅月初七
Title: （已解决）执行hive初始化时一直报错：Failed to get schema version.和 Failed to load driver
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/817977/
转载文章受原作者版权保护。转载请注明原作者出处！