Community
Training
Partners
Support
Cloudera Community
Cloudera Community
Announcements
Product Announcements
Community Announcements
What's New @ Cloudera
Support
Support Questions
Community Articles
Using the Community
Getting Started
Intros and Suggestions
Community Tips
Groups
Cloudera Data Analytics (CDA)
Sign In
Community Articles
Find and share helpful community-sourced technical articles.
All community
This category
Community Articles
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Advanced Search
Cloudera Community
Support
Community Articles
Hive metastore DB Connection verification from Com...
Options
Subscribe to RSS Feed
Mark as New
Mark as Read
Bookmark
Subscribe
Printer Friendly Page
Report Inappropriate Content
Options
Subscribe to RSS Feed
Mark as New
Mark as Read
Bookmark
Subscribe
Printer Friendly Page
Report Inappropriate Content
Hive metastore DB Connection verification from Command line
Labels
(1)
Labels:
Apache Hive
rrrajesh
Expert Contributor
Created on
01-03-2018
07:22 PM
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!
3,844 Views
0
Kudos
Announcements
What's New @ Cloudera
[RELEASED] Cloudera Streaming Analytics 1.14 for Cloudera Pu...
What's New @ Cloudera
Cloudera Data Engineering 1.23: Access Spark from Your Favor...
What's New @ Cloudera
HBase REST server scaling support is Generally Available
What's New @ Cloudera
New CLI option in the update-database command
What's New @ Cloudera
New Action menu item in the Cloudera Operational Database UI
View More Announcements
Version history
Last update:
01-03-2018
07:22 PM
Updated by:
rrrajesh
Contributors
rrrajesh
Top Kudoed Authors
User
Count
TimothySpann
766
sshimpi
379
KuldeepK
316
cstanca
309
abajwa
270
View Full Leaderboard