@Adil BAKKOURI You have a couple of issues, could you first align your MySQL server time to your local time. Can you re-run this command # Check your databases system time mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2019-04-13 20:41:04 |
+---------------------+ There are three places where the timezone might be set in MySQL in the file "my.cnf" in the [mysqld] section by setting default-time-zone='+00:00' To set it use either one: mysql> SELECT @@session.time_zone;
+---------------------+
| @@session.time_zone |
+---------------------+
| SYSTEM |
+---------------------+
1 row in set (0.00 sec) Now you can set it i.e SET time_zone = 'Europe/Helsinki'; SET time_zone = "+00:00"; SET @@session.time_zone = "+00:00"; # Re-Install the mysql jdbc connector yum install -y mysql-connector-java # Setup Ambari ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar You may need to recreate the hive user and schema and then after a successful startup, you can drop the old user and schema. Assuming your old hive user was [hiveold] # New Hive user assuming the root user password is {welcome1} mysql -u root -pwelcome1
create database hivedb;
CREATE USER 'hive'@'%' IDENTIFIED BY '{hive_password}';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost';
GRANT ALL PRIVILEGES ON hivedb.* TO 'hive'@'%';
GRANT ALL PRIVILEGES ON hivedb.* TO 'hive'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON hivedb.* to 'hive'@'localhost' identified by '{hive_password}';
GRANT ALL PRIVILEGES ON hivedb.* to 'hive'@'{YOUR_HOST_FQDN}' identified by '{hive_password}';
GRANT ALL PRIVILEGES ON hivedb.* TO 'hive'@'{YOUR_HOST_FQDN}';
GRANT ALL PRIVILEGES ON hivedb.* TO 'hive'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES; quit; After all the above now try to configure hive through Ambari and after saving the configuration your hive should start normally. Please keep me posted.
... View more
