1. Login to ambari database hosted server.   2. Take the backup of database. Replace XXXXXX with correct pasword nohup mysqldump -u root -pXXXXXX --databases ambari >/ambari.sql & 3. Login to mysql with root or ambari account and remove hive keytabs. delete from kerberos_principal_host where principal_name like '%hive%'; delete from kerberos_principal where principal_name like '%hive%'; 4. Restart Ambari server. 5. Regenerate the keytabs with valid   account 6. Start the Node manager.   Note: its not only for Hive.. we can remove based on error. as caches in ambari database prevents to regenerate again  ... View more

Follow below steps to fix the issue.    Temp Solution:   login to mysql of ranger using root or ranger credentials.  mysql -u root -p XXXXX use ranger; select * from vx_trx_log limit 1; u will get error message like "ERROR 1055 (42000): Expression #1 of SELECT list " execute below command to set global variables to refresh the admin page.  SET GLOBAL SQL_MODE = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';   wait for few mins and refresh the page.   Permanent solution.    Open MySQL config file(my.cnf) file and change/add sql_mode as given below under [mysqld] section of the file sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Restart MySQL server after shaving changes. .      ... View more