in hdp 3.1 the file is in app/hbase/data/Wal's you will find the server name that wont start ==> delete it ... View more

@sluangsay @TimothySpann @skumpf @bmathew  @shishir_saxena4 @srai1 @rajkumar_singh @qiwang  ... View more

@sayaeWajood  @saranvisa  ... View more

do you have any idea about creating hive table in arabic language (hdp 3.1) , is not a valid table name . there should be a way to let hive metadata accept utf-8 for creating tables ? ... View more

hi elmar the best way to distribute your services is using 4 machines  in your case  just add the services and ambari will distribute them thru the 4 machines.   first machine : primary namenode hbase zookeeper ... second machine : secondary namenode and any services you want (hive for example) third machine : ambari metrics collector forth machine : data node (check client box in installation steps) answer is tested  best regards.   ... View more

  ambari installation full steps centos7 hostnamectl set-hostname your_hostname systemctl get-default systemctl set-default multi-user.target nano(vim) /etc/hosts  ==>  add , ip_of_machine  name_of_machine systemctl disable firewalld vim /etc.sysconfig/network ==> HOSTNAME=machine_hostname                                                     NETWORKING=yes vim /etc/sysctl.conf ==> add, vm.swappiness=10 vim /etc/selinux/config ==> change ,selinux=disabled yum install ntp systemctl enable ntp systemctl start ntp   vim /etc/rc.local==> enbale huge page :add ,   echo never > /sys/kernel/mm/transparent_hugepage/defrag echo never > /sys/kernel/mm/transparent_hugepage/enabled;  cd /etc/yum.repos.d yum install wget yum install ambari repo and favorite one here is 2.7.3 wget -nv http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.7.3.0/ambari.repo -O /etc/yum.repos.d/ambari.repo  yum repolist yum install ambari-server ambari-agent vim /etc/ambari-agent/conf/ambari-agent.ini ==>hostname=your_hostname                                        in security section add ==>force_https_protocol=PROTOCOL_TLSV1_2 ambari-server setup ==> dont enter advanced setup and install jdk ambari-server start go to the web page enter (hostname:8080) or machine_ip:8080 enjoy . please accept the answer after trying; best regards.   ... View more

there are many repo for ambari and 2.7.5 is not paid prefer to download it directly from https://cwiki.apache.org/confluence/display/AMBARI/Installation+Guide+for+Ambari+2.7.5   or install 2.7.3 ambari repo for hdp 3.1.4 for ubuntu : http://www.olric.org/2019/09/install-single-node-hortonworks-data.html or https://docs.cloudera.com/HDPDocuments/Ambari-2.7.3.0/bk_ambari-installation/content/ch04s01s06.html for centos install this repo https://docs.cloudera.com/HDPDocuments/Ambari-2.7.3.0/bk_ambari-installation/content/download_the_ambari_repo_lnx7.html ... View more

you shoul either use ssh (id_rsa) or install ambari-agent on all hosts after ambari agent is installed (change the  /etc/ambari-agent/conf/ambari-agent.ini ) and set the hostname of ambari-server machine for all machines  then change the /etc/hosts file ( ip_of_machine1 name_of_machine1                                                   ip_of_machine2 name_of_machine2....) then ==> ambari-agent restart for all machines  trusted and tested  ... View more

first for ubuntu : on the ambari server machine ( nano /etc/postgres/10/main/pg_hba.conf ==> local all postgres peer                                                                           local all all trust                                                        host all postgres 127.0.0.1/32 trust                                                        ipv6 trust add                                                 local all ambari,mapred md5                                                        host all ambari,mapred 0.0.0.0/0 md5                                                        host all ambari,mapred ::/0 md5                                                        host hive hive 0.0.0.0/0 md5 nano /postgres.conf ==> uncomment listen_addresses = '*'                                                      and port = 5432 instal jdk-8 wget the jdbc.jar file with in a known directory (https://jdbc.postgresql.org/) use ambari-server setup --jdbc-db=postgres --jdbc-driver=/path/to/postgres/name of installed file in postgres : create user with password, create database and grant all privileges ; in ambari setup :just enter advanced setup (and dont change the default parameters, just press enter note : MAKE SURE THAT DATABASE URL IN AMBARI WEB PAGE(STEP 7 :CUSTOMIZE SERVICES) IS TAKING THE NAME OF THE MASTER MACHINE WHERE  AMBARI SERVER AND JDBC DRIVER ARE INSTALLED FOR EXAMPLE : jdbc:postgresql://master.hadoop.com:5432/hive    (AND THIS IS THE ISSUE IN YOUR CASE HERE ) RESOLVED THE SAME STEPS FOR CENTOS 7 JUST INSTALL WGET BEFORE Good luck. ... View more