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...
Announcements
Celebrating as our community reaches 100,000 members!
Thank you!
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,506 Views
0
Kudos
Announcements
Product Announcements
[ANNOUNCE] Cloudera on Public Cloud Runtime 7.2.18 is GA!
What's New @ Cloudera
Cloudera Operational Database (COD) supports enhancements to...
Community Announcements
March 2024 Community Highlights
Community Announcements
Celebrating 100,000 Members: A Journey of Growth and Connect...
Product Announcements
[ANNOUNCE] New Cloudera JDBC Connector for Apache Hive 2.6.2...
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