@ilia kheifets I assume you have installed Postgres or Mysql and run the corresponding on host ubuntu17 ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql-jdbc.jar I have used the same user, password and database name for simplicity. For Postgres As the root switch to Postgres user # su - postgres postgres@ubuntu17:~$ psql psql (9.5.9) Type "help" for help. Hive user/database setup postgres=# DROP DATABASE if exists hive; postgres=# CREATE USER hive PASSWORD 'hive'; postgres=# CREATE DATABASE hive OWNER hive; postgres=# grant all privileges on database hive to hive; postgres=# \q Oozie user/database setup postgres=# DROP DATABASE if exists oozie; postgres=# CREATE USER oozie PASSWORD 'oozie'; postgres=# CREATE DATABASE oozie OWNER oozie; postgres=# grant all privileges on database oozie to oozie; postgres=# \q Ranger user/database setup postgres=# DROP DATABASE if exists rangerdb; postgres=# CREATE USER rangerdb PASSWORD 'rangerdb'; postgres=# CREATE DATABASE rangerdb OWNER rangerdb; postgres=# grant all privileges on database rangerdb to rangerdb; postgres=# \q Edit the pg_hba.conf vi /etc/postgresql/9.5/main/pg_hba.conf at the end of the file in example below my ambari,hive and ranger are using postgres database local all ambari,hive,oozie,ranger,mapred md5 host all ambari,hive,oozie,ranger,mapred 0.0.0.0/0 md5 host all ambari,hive,oozie,ranger,mapred ::/0 md5 Then restart postgres /etc/init.d/postgresql restart For Mysql In this exampel I assume the root password is hadoop hive user # mysql -u root -phadoop CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive'; GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost'; CREATE USER 'hive'@'%' IDENTIFIED BY 'hive'; GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%'; CREATE USER 'hive'@'<HIVEMETASTORE_FQDN>' IDENTIFIED BY 'hive'; GRANT ALL PRIVILEGES ON *.* TO 'hive'@'<HIVEMETASTOREFQDN>'; FLUSH PRIVILEGES; Create the Hive database The Hive database must be created before loading the Hive database schema. mysql -u root -phadoop CREATE DATABASE hive; quit; Oozie user setup mysql -u root -phadoop CREATE USER 'hive'@'%' IDENTIFIED BY 'hive'; GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%'; FLUSH PRIVILEGES; Create the Oozie database The oozie database must be created before loading the oozie database schema. mysql -u root -phadoop CREATE DATABASE oozie; After either the MySQL or Postrges setup, now in the Ambari UI hive setup see attached screenshots, you will need to use the credentials setup earlier. Choose use existing PostgreSQL/MySQL database In the initial setup, it will ask you to test the connectivity between hive and Postgres this MUST succeed.In both setups just make sure for both cases the below correct entries are chosen. Hive Database Database Name Database Username Database Password JDBC Driver class Database URL Hive Database Type Hope that helps ... View more

@uri ben-ari Check /etc/hosts of the Ambari server and make sure the old entries are removed ,realce with the new one. DELETE all host components mapped to this host in this case DATANODE curl -u admin:admin -H "X-Requested-By: ambari" -X DELETE http://AMBARI_SERVER_HOST:8080/api/v1/clusters/CLUSTERNAME/hosts/HOSTNAME/host_components/DATANODE DELETE the host curl -u admin:admin -H "X-Requested-By: ambari" -X DELETE http://AMBARI_SERVER_HOST:8080/api/v1/clusters/CLUSTERNAME/hosts/HOSTNAME And you will need to restart all stale config ... View more

@Neha G In a kerberized cluster there are 2 types of keytabs or principals headless and service principals. Headless principals are not bound to a specific host or node and are presented like @ SRV.COM Service principals are bound to a specific service and host or node, and are presented like with syntax: /@ SRV.COM So when you initialize the hdfs.headless.keytab is as DoAs so the user will take hdfs permissions ... View more

@ilia kheifets Can you enlighten me I see a mixture of Mysql and postgres command in your new posting. We can resolve your issue with ONLY postgres installation because the mixture looks confusing. It wont affect any service except Hive and oozie or Ranger iif you intend to and Ranger for authorization, authentication and administration of security policies ... View more

@ilia kheifets Is this the correct URL to you hive database? jdbc:hive2://ambari-master.test.com:10015/default I see error "Connection refused\' -e \'Invalid URL\'\' returned 1. Error" Can you walk me through the setup of the databases for hive,oozie? Was it with Mysql or Postgres? ambari-server setup -s ( -s silent install) should work with the embedded postgres, so I can tell why it didn't work in your case could one of the standard OS preparations that you ignored. ... View more

@Kumar Peddibhotla Please can you paste here how you proceeded step by step so I can validate, please remember to obscure ONLY import inputs like IP, REALM ,HOSTNAME etc It's important to see and hence be able to debug. Did you add Druid as a service with Ambari, how can I reproduce your errot? ... View more

@ilia kheifets Hive needs a metastore database to store structure information of the various tables and partitions in the warehouse. Oozie stores the workflow/scheduler details in the relational database You could use postgres instead of Mysql and the creation is even easier see below Hive database In the below example the database and user is "hive" # su - postgres postgres@ubuntu17:~$ psql psql (9.5.9) Type "help" for help. postgres=# DROP DATABASE if exists hive; postgres=# CREATE USER hive PASSWORD 'hive'; postgres=# CREATE DATABASE hive OWNER hive; postgres=# grant all privileges on database hive to hive; postgres=# \q Oozie database In the below example the database and user is "oozie" postgres=# DROP DATABASE if exists oozie; postgres=# CREATE USER oozie PASSWORD 'oozie'; postgres=# CREATE DATABASE oozie OWNER oozie; postgres=# grant all privileges on database oozie to oozie; postgres=# \q After the above has been successful during the Ambari UI setup use the hive and oozie info to set up these components. Can you let me know if the installation succeeded ... View more

@Kumar Peddibhotla Good I will wait for your feedback, the output of my REALM is just an example placeholder and for sure it won't match yours but the methodology is the same ... View more

@Kumar Peddibhotla You need to go through this druid setup in a kerberized environment if you haven't yet done so Druid-Kerberos. After kerberisation check whether druid keytab was generated in /etc/security/keytabs/druid.keytab. If so then you will need to kinit the /etc/security/keytabs/druid.keytab. with the correct principal which you can obtain by running # klist -kt /etc/security/keytabs/druid.keytab The output could be something like this $ klist -kt /etc/security/keytabs/druid.keytab Keytab name: FILE:/etc/security/keytabs/druid.keytab KVNO Timestamp Principal ---- ----------------- ------------------------------- 1 02/02/17 23:00:12 druid/FQDN@REALM 1 02/02/17 23:00:12 druid/FQDN@REALM To get a valid Kerberos ticket you will need to kinit kt $keytab $ principal $ kinit -kt /etc/security/keytabs/druid.keytab druid/FQDN@REALM Now the errors should disappear, please let me know if that helped ... View more