Hive metastore DB Connection verification from Command line:-
You can run the following on any node where ambari agent installed on the cluster,
You need the following information to run this test.
You can use this to validate if the password stored in ambari and the actual mysql db password are same.
1. mysql db hostname
2. mysql db port number
3. mysql database name which hive metastore uses
4. mysql username
5. mysql password
Syntax:-
java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/share/java/mysql-connector-java.jar -Djava.library.path=/usr/lib/ambari-agent org.apache.ambari.server.DBConnectionVerification "jdbc:mysql://<mysql db hostname>:<mysql db port number>/<mysql database name>" "<mysql username>" "<mysql password>" com.mysql.jdbc.Driver
Example:-
/usr/jdk64/jdk1.8.0_112/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/share/java/mysql-connector-java.jar -Djava.library.path=/usr/lib/ambari-agent org.apache.ambari.server.DBConnectionVerification "jdbc:mysql://test.openstacklocal:50001/hive" hive hive com.mysql.jdbc.Driver
Connected to DB Successfully!
Subscribe to:
Post Comments (Atom)
Boost Your Download Speed with lftp Segmentation
Looking for a faster way to download files via sftp to a Linux machine? Try using "lftp" instead. This tool offers segmented downl...
Other relevant topics
-
+++++++++++++++++++++++++++++++++++++++++++ How to move a region from 1 RS to another Region server:- ++++++++++++++++++++++++++++++++++++...
-
Hive metastore DB Connection verification from Command line:- You can run the following on any node where ambari agent installed on the ...
-
DistCp (distributed copy) is a tool generally used for large inter/intra-cluster copying in hadoop. But it can also be used to copy the f...
No comments:
Post a Comment