About Udhav

stevenmatison · ‎06-19-2020

@Udhav It appears your mysql is not running after a restart. Try this: service mariabdb start chkconfig mariadb on Also, I would refrain from using "localhost" or "127.0.0.1". This opens doors for networking and permissions issues. Please always use an FQDN, for example: c3701.ambari.apache.org that is mapped to public IP addresses on any given node via /etc/hosts. That FQDN should also be the hostname for each node as well. If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post. Thanks, Steven @ DFHZ

Udhav · ‎05-31-2020

Hey @stevenmatison, its working now thanks for the help.

Udhav · ‎05-27-2020

Hello @ronics, I had the same error few days back, Following is the exception Exception in thread "main" java.lang.RuntimeException: com.ctc.wstx.exc.WstxParsingException: Illegal character entity: expansion character (code 0x8 at [row,col,system-id]: [3215,96,"file:/home/hadoop/hive/conf/hive-site.xml"] Open hive-site.xml file and go to the 3215th row. It is throwing that error, as there is a special character () between the words for and transactional . Either delete that character or copy and paste (replace) which the next 2 lines. Ensures commands with OVERWRITE (such as INSERT OVERWRITE) acquire Exclusive locks for transactional tables. This ensures that inserts (w/o overwrite) running concurrently are not hidden by the INSERT OVERWRITE. This should solve your problem.

Udhav · ‎05-23-2020

i tried going to Help -> show logs in file. but there are many log files. which one should i share?

Udhav · ‎05-18-2020

Thank You @stevenmatison its working now.

Udhav · ‎04-23-2020

Thank u @stevenmatison! its working now.

Udhav · ‎04-22-2020

@stevenmatison Thank you very much!

stevenmatison · ‎04-16-2020

@Udhav You need to map a FQDN (fully qualified domain name) to your "localhost" via /etc/hosts For example I often use "hdp.cloudera.com". cat /etc/hosts | grep 'cloudera.com': 1xx.xxx.xxx.xxx hdf.cloudera.com 1xx.xxx.xxx.xx hdp.cloudera.com Next you put the FQDN in the list of hosts during Cluster Install Wizard. Be sure to complete the next required steps for ssh key, agent setup, etc. When the Confirm Hosts modal fails, you can click the Failed link, open modals and get to the full error. The easiest way for me to spin up ambari/hadoop in my computer is using AMBARI VAGRANT: https://cwiki.apache.org/confluence/display/AMBARI/Quick+Start+Guide This provides an easy way to spin up 1-X number of nodes in my computer, and it handles all the ssh-keys and host mappings. Using this I can spin up ambari on centos with just a few chained commands: wget -O /etc/yum.repos.d/ambari.repo http://public-repo-1.hortonworks.com/ambari/centos7/2.x/updates/2.7.0.0/ambari.repo && yum --enablerepo=extras install epel-release -y && yum install java java-devel ambari-server ambari-agent -y && ambari-server setup -s && ambari-server && ambari-server start && ambari-agent start

Online	Offline
Last Visited	‎07-23-2020 09:44 AM

Date Registered	‎04-16-2020 05:50 AM
Last Visited	‎07-23-2020 09:44 AM
Total Messages Posted	25
Total Kudos Received	4

Re: Ambari server start always fails

Re: Exception while connecting hive and sparkThe r...

Re: Hive with mysql metastore issue

Re: Issue in Creating Project Using Spark 2.4.5 in...

Re: Hive MetaStore always fails to start

Re: Confirm Host step always fails.

Re: Not able to Setup passwordless ssh for ambari ...

Re: Having Issue in naming Target Hosts?