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?
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?
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...
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.