Member since
01-20-2020
2
Posts
2
Kudos Received
0
Solutions
07-08-2021
03:38 AM
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
05-19-2020
04:12 AM
2 Kudos
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