（已解决）执行hive初始化时一直报错：Failed to get schema version.和 Failed to load driver

 

 

 这是我出现的错误，最开始是图二，在我的不断尝试下变成图一，在变成图二，而且没有提示

出错了在博客上搜索是我的思路之一，网上的解决办法有改权限，有重置密码，这些我的都没有问题，

由于不断的试错，越来越没有思路，请教了老师

第一步先检查一下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 了  如图（耗费一下午成功了）