Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Specify RDS for Hive Metastore in Cloudbreak

Specify RDS for Hive Metastore in Cloudbreak

Expert Contributor

Hi,

We want to use external hive metastore that is backed by Amazon RDS in cloudbreak. In cloudbreak UI -> Show Advanced Options -> we can configure DB properties for Ambari but not sure about hive.

Can we configure the properties(javax.jdo.option.ConnectionURL, javax.jdo.option.ConnectionUserName, javax.jdo.option.ConnectionPassword) for external hive metastore in blueprint.json (hive-site.xml) or any other way we can configure it? Do we have any documentation on how to configure Amazon RDS in cloudbreak?

https://community.hortonworks.com/questions/67731/cloudbreak-for-aws-and-specifying-rds-for-hivemeta...ml

As per the above link, we can add environment variables in cloudbreak deployer's Profile. But if we are putting the variables in Profile file then will it apply only for Hive Service?

Thanks.

3 REPLIES 3

Re: Specify RDS for Hive Metastore in Cloudbreak

Guru

Hi @Shyam Shaw

Are you using the Hortonworks Data Cloud product?

I believe that setup if only for the Ambari DB if you are not using the Hortonworks Data Cloud product. The supported databases for HDP (and not HDC) are listed here: https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin#AdminManualMetastoreAdmi...

Re: Specify RDS for Hive Metastore in Cloudbreak

Expert Contributor

@Sonu Sahi

Thanks for your response. We are using Cloudbreak to launch HDP cluster on EC2 instances. We now want to use external Hive Metastore backed by Amazon RDS. It seems that we need to configure the DB properties in blueprint.

When we launch the cluster using Ambari, we can test the connection for external DB's for services like hive, oozie etc. but not sure how we can do this in Cloudbreak.

Re: Specify RDS for Hive Metastore in Cloudbreak

Expert Contributor
Don't have an account?
Coming from Hortonworks? Activate your account here