Cloudera Community
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community Blogs — Read the Announcement
jsensharma
user rank
user rank
Master Mentor

Re: sqoop import error

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 11:50 PM
‎03-08-2018 11:50 PM
Now the error says that it is not able to communicate with MySQL server. So please check if your mysql server is running file and listening to "hadoop:3306" port # netstat -tnlpa | grep 3306 # hostname -f # ps -ef | grep mysql . Also please check if there is any issue/error logged in mysql log. . ... View more

Re: sqoop import error

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 11:48 PM
‎03-08-2018 11:48 PM
@Aymen Rahal Do you see the following symlink exist with the following user permission: # ls -l /usr/hdp/current/sqoop-client/lib/mysql-connector-java.jar lrwxrwxrwx. 1 root root 40 Jun 9 2017 /usr/hdp/current/sqoop-client/lib/mysql-connector-java.jar -> /usr/share/java/mysql-connector-java.ja . Also do you see the following command shows the class found? # jar -tvf /usr/share/java/mysql-connector-java.jar | grep 'com.mysql.jdbc.Driver' 919 Tue Jan 01 00:00:00 UTC 1980 com/mysql/jdbc/Driver.class . ... View more

Re: sqoop import error

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 11:26 PM
‎03-08-2018 11:26 PM
@Aymen Rahal If you do not have the mysql driver in your host then please install it as following: # yum install mysql-connector-java* # cp -f /usr/share/java/mysql-connector-java.jar /usr/hdp/current/sqoop-client/lib/ . If you do not want to use "yum" to install mysql-connector-java then you can also download the tar archive of the connector from the following site and then put the extracted JAR (mysql-connector-java*.jar) inside the "usr/hdp/current/sqoop-client/lib/" https://dev.mysql.com/downloads/connector/j/ . ... View more

Re: sqoop import error

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 11:19 PM
‎03-08-2018 11:19 PM
@Aymen Rahal Following link talks about it in more detail: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.4/bk_data-movement-and-integration/content/apache_sqoop_connectors.html ... View more

Re: sqoop import error

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 11:17 PM
‎03-08-2018 11:17 PM
@Aymen Rahal You will need to download the mysql-connector-java (MySQL JDBC driver) and then put it to the following location: # cp -f /usr/share/java/mysql-connector-java.jar /usr/hdp/current/sqoop-client/lib/ The you can run the Sqoop command something like following: # su -l sqoop -c "sqoop import --connect jdbc:mysql://hadoop/Testdb --table widgets -m 4 --username root --password CHANGEME --driver com.mysql.jdbc.Driver" . ... View more

Re: Tomcat Installation in Azure on port 2222

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 08:44 PM
‎03-08-2018 08:44 PM
@Vishal Gupta The prerequisite of setting up the Azure Sandbox is described here: https://hortonworks.com/tutorial/sandbox-deployment-and-install-guide/section/4/ So please check if you have done the Local Forwards properly or not as described in the above link? ... View more

Re: Ambari UI is not showing Active/Standby Resour...

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 08:39 PM
1 Kudo
‎03-08-2018 08:39 PM
1 Kudo
@Bhushan Kandalkar You are getting error as following: keytool error: java.io.IOException: Keystore was tampered with, or password was incorrect<br> Above error indicates that you might be entering an incorrect store password of your JKS keystore (Or the keystore is corrupted). So if you want to verify if your Keystore is good and your password is correct or not, Please try to list the keystore using the same keystore password which is failing for you: # keytool -list -v -keystore /etc/ambari-server/bhushan-kandalkar-87127-1.novalocal.jks . If you get the same error even while listing the keystores default certificates then it means either you are entering the password incorrectly Or bhushan-kandalkar-87127-1.novalocal.jks file is tempered. ... View more

Re: Getting Error in Hive View 2.0

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 08:32 PM
1 Kudo
‎03-08-2018 08:32 PM
1 Kudo
@Bhushan Kandalkar You are getting the error : Caused by: java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target You are getting this error because you have enabled SSL on HDFS, YARN, MapReduce and HIVE service But you have not imported the SSL Certificates of these services to Ambari Server's Truststore. So please do this: 1. Enable the truststore on Ambari Server host (if not already done) like: https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.5/bk_ambari-security/content/set_up_truststore_for_ambari_server.html 2. Once the truststore is setup on amabri server then you will need to import the certificates from these services (HDFS, YARN, MapReduce and HIVE) to the Ambari Truststore. . For more information on this please refer to the note from: Configure a Trust Store : https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.5/bk_ambari-views/content/preparing_ambari_for_views.html If your Ambari Server instance is configured for HTTPS, you must configure a trust store so that the deployed views accept the certificate used by the Ambari Server during API communications. . ... View more

Re: ambari-server High availability (HA)

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 11:49 AM
‎03-08-2018 11:49 AM
@Anurag Mishra Currently the HA feature for Ambari Server is not available. However it can be by enabling a rapid failover mechanism (an active-passive setup) through an external monitoring tool e.g. Upstart, Supervisor or some other Daemon tool. In this case One of the server is kept active while the other is stopped. The responsibilities of the external monitoring service are: Ensure there is only one active instance of Ambari Server Monitor the active instance and if it’s down then make a decision to either bring the same instance back up or the replacement instance Ensure that the agents are re-configured to communicate with the active Ambari Server instance Requirements for HA The Ambari DB must be an external DB instance (do not use embedded postgres) Both Ambari Server instances must be configured similarly (options available via ambari-server setup command) Appropriate load-balancer setup to route client requests to the active Ambari Server instance . Reference: https://community.hortonworks.com/questions/402/how-to-setup-high-availability-for-ambari-server.html https://community.hortonworks.com/questions/89555/ha-for-ambari.html Feature Request: The improvement request is still in progress: https://issues.apache.org/jira/browse/AMBARI-17126 ... View more

Re: Tomcat Installation in Azure on port 2222

by Master Mentor Master Mentor in Support Questions
‎03-08-2018 11:39 AM
‎03-08-2018 11:39 AM
@Vishal Gupta Are you talking about Azure HDP Sandbox? If yes, then there is a separate way to add ports. As it runs on docker container. Please see the following guides to know how sandbox exposes the ports. Add ports to Azure HDP Sandbox Docker: https://hortonworks.com/tutorial/sandbox-port-forwarding-guide/section/4/ For adding new Ports: https://community.hortonworks.com/articles/65914/how-to-add-ports-to-the-hdp-25-virtualbox-sandbox.html (even though this link says VirtualBox but should be fine in your case) ... View more
Contact Me
Community Statistics
Member Since ‎03-14-2016 01:07 PM
Last Visited
Posts 4,721
Kudos received 1096