@AarifAkhter  Please check the below doc if you ahve specified the Maria DB type correctly as mentioned in the following doc: https://docs.cloudera.com/HDPDocuments/Ambari-2.7.5.0/administering-ambari/content/amb_using_ambari_with_mysql_or_mariadb.html # ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar ... View more

@AarifAkhter  Looks like you have  not done the Database setup correctly  thats the reason it is failing to determine the MariaDB settings   com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'MariaDB'   Please share the exact ambari server version and the output of the following commands: # grep 'jdbc' /etc/ambari-server/conf/ambari.properties # ambari-server --version .  Have you setup the maria Db correctly?   Is MariaDB supported version listed for your Ambari version in Support matrix?   https://supportmatrix.hortonworks.com/ ... View more

@dewi  What do you mean by "I've tried setup hiveserver manually " ? Can you please share the details how you did this?  Or have you used to setup Hive?   Also can you please share the logs of HiveServer2 for it's Manual command line startup?  Did you notice any error in the hiveserver2 log when you attempted to start it via command line ?   If yes then can you please share the hive conf and full log ?  (you can mask the passwords/hostname) . Also have you made any special config changes like hive.server2.support.dynamic.service.discovery? Have you disabled the "hive.server2.support.dynamic.service.discovery" setting in your "Advanced hive-site" ? It will be good to see the HS2 log and Hive Configs. ... View more

@dewi  The problem does not look seem to be related to the Znode. Once the Hive Server2 is started successfully then you should see the znode.   The issue seems to be the use of "localhost". As we see the following output in your output. Connection failed on host localhost:10000 . . beeline -n hive -u 'jdbc:hive2://localhost:10000/;transportMode=binary' Ideally those connection strings should be showing the FQDN (Fully Qualified Hostname) instead of showing "localhost". So please check if the Hive Server config is hardcoded with "localhost" address anywhere or if there is anything wrong with the hostname "/etc/hosts" ...etc # grep 'localhost' /etc/hive/conf/*.xml .   Manual Startup Testing Also please verify if you are able to start the HiveServer2 using command line. As mentioned in  # su - hive # nohup /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=/tmp/hiveserver2HD.out 2 /tmp/hiveserver2HD.log   . Then check the port 10000 is listening to 0.0.0.0 OR localhost? # netstat -tnlpa | grep `cat /var/run/hive/hive-server.pid` . .   ... View more

@asmarz  Please refer to the following doc in order to know how you can enable SPNEGO authentication. Once you have enabled Kerberos for your cluster after that you can also enable the SPNEGO authentication. The following doc explains how to configure HTTP authentication for Hadoop components in a Kerberos environment.   By default, access to the HTTP-based services and UIs for the cluster are not configured to require authentication.   1. https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/authentication-with-kerberos/content/authe_spnego_enabling_spnego_authentication_for_hadoop.html 2. https://docs.cloudera.com/HDPDocuments/Ambari-2.7.5.0/managing-and-monitoring-ambari/content/amb_start_kerberos_wizard_from_ambari_web.html ... View more

@singm125    Which version of Ambari are you using ?  I see that there is a JIRA opened and addressed in Ambari 2.7.4 for addressing the "null" user appearing in "ambari-audit.log"  .   [JIRA] Ambari audit log shows "null" user when executing an API call : https://issues.apache.org/jira/browse/AMBARI-25234   ... View more