@Sampath Kumar It might happen if the oozie shared library is not updated. Can you please try recreating the oozie sharelib and then test again. ... View more

@Anurag Mishra Your error "table is encrypted: java.lang.IllegalArgumentException: Wrong FS" " looks similar to the one described in the following Support KB article: https://community.hortonworks.com/content/supportkb/48759/javalangillegalargumentexception-wrong-fs-running.html ... View more

@sharath kumar A S As the error is basically "Connection Refused" jdbc:hive2://xxx.yyy.com:10000/default java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0) So can you please check if the Port 10000 is opened on the HS2 host? # netstat -tnlpa | grep 10000 . Also please check if the port 10000 is accessible from the host where you are Spark2 is installed. This is to isolate any Connectivity / Firewall issue: # nc -v xxx.yyy.com 10000 (OR) # telnet xxx.yyy.com 10000 . ... View more

@Praveen Atmakuri If this resolved your query/issue then please mark this HCC thread as answered by clicking on "Accept" link on the correct answer, That way it will help other HCC users to quickly find the answers. ... View more

@Michael Bronson I was re-reading this thread and looks like i have misunderstood your requirement. Can you please confirm if my understanding regarding your query is correct or not? Based on your issue description i understood that you want to configure 1. A Single Node Cluster. 2. That single node cluster should have "one Journal node machine ( master ) + worker + kafka". Means in thjis Single Node you want to install a JournalNode + DataNode + Kafka Broker My Query: In this case where will the NameNode be. Also as you are using a term Journal Node which is available in NameNode High Availability mode . So are you planning to install both the name Nodes in the same Single Host (by making some port conflict resolution) ? ... View more

@Liana Napalkova Basicaly the steps will be somethign like following: 1. You can install MySQL 5.5 or later. On the Ambari host, install the JDBC driver for MySQL, and then add it to Ambari: # yum install mysql-connector-java* If the MySQL mysql-connector-java is not available in your YUM repo then you can download the Driver manually on the ambari server host "mysql-connector-java-5.1.35.zip" or later JDBC driver from : https://dev.mysql.com/downloads/connector/j/5.1.html then extract it on ambari server host. Put the connector jar in some location like: /usr/share/java/mysql-connector-java.jar 2. Run the ambari server setup command as following: (then restart ambari server) # sudo ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar 3. Now install the MySQL Server as following on the desired host. In your case in may be "xxxambarislave2.local.xxx.org". SSH Log in to the node on which you want to install the MySQL. Then install MySQL and the MySQL community server, and start the MySQL service: # yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm # yum install mysql-community-server # systemctl start mysqld.service 4. Obtain a randomly generated MySQL root password: # grep 'A temporary password is generated for root@localhost' /var/log/mysqld.log |tail -1 5. Reset the MySQL root password. Enter the following command, followed by the password you obtained in the previous step. MySQL will ask you to change the password # /usr/bin/mysql_secure_installation The from ambari UI you can install Hive Service and mentioned the MySQL server details. . ... View more

@Liana Napalkova As due to licensing issues the mysql server will not be installed by default (unlike earlier versions) so you will have to manually insatll the MySQL Server on the host "xxxambarislave2.local.xxx.org". adn then after starting the MySQL server on that host you can then run the ambari Hive Service "Add Service" wizard. So basically the detailed steps to use MySQL for Hive (In HDP 2.6.4) is describe din the following section as a pre requisite: "Installing and Configuring MySQL" : https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.4/bk_command-line-installation/content/meet-min-system-requirements.html ... View more

@Michael Bronson HDP sandbox is a Single Node Cluster. Which can be downloaded from https://hortonworks.com/products/sandbox/ Following is the link which shows how to use the HDP Sandbox (Single Node Cluster) https://hortonworks.com/tutorial/learning-the-ropes-of-the-hortonworks-sandbox/ ... View more