AWS RDS as External Hive Metastore for AWS EMR

Question

I have created a AWS RDS instance of MySQL type and want this instance to use as a external hive metastore for EMR.I am creating a EMR and setting the property in "edit software setting" for external hive metastore but getting some errors like"terminating bootstrap failure". Please help me and thanks in advance.

Answer 1

Try to add this Configuration in Edit Software Settings Tab :

[{"classification":"hive-site","properties":{"javax.jdo.option.ConnectionUserName":<YOUR_MYSQL_USER>,"javax.jdo.option.ConnectionDriverName":"com.mysql.jdbc.Driver","javax.jdo.option.ConnectionPassword":<YOUR_MYSQL_PASSWORD>,"javax.jdo.option.ConnectionURL":<YOUR_CONNECTION_URL>}}]

Thanks

Answer 2

I am creating a EMR cluster with default hive meta store , after which i am overriding the hive-site.xml with some property which are pointing the aws rds instance as hive metastore , everything is fine , but after restarting the hive server , i am not able to use RDS as hive metastore. It is still usin the default hive metastore created by EMR.