Hive所在的机器重新启动后又报类似的错误,可能原因有:
mariadb数据库服务没有起来,执行以下命令:
systemctl start mariadb #启动MariaDB
systemctl stop mariadb #停止MariaDB
systemctl restart mariadb #重启MariaDB
systemctl enable mariadb #设置开机启动
试用ps -ef|grep mariadb查看服务,已经启动了,但是hive还是有问题,估计是连接数据的问题,权限问题?
MariaDB [mysql]> select Host,User from user;
+---------------+------+
| Host | User |
+---------------+------+
| % | hive |
| % | root |
| 127.0.0.1 | root |
| ::1 | root |
| hadoop-slave1 | |
| hadoop-slave1 | root |
| localhost | |
| localhost | root |
+---------------+------+
8 rows in set (0.01 sec)
MariaDB [mysql]> exit;
可见,hive账号是存在的,但是。。。但是我试用hive用户和hive命令,居然登陆不进去,真的是世界之大