Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings in the Hadoop Environment
  4. Mapping Sources in the Hadoop Environment
  5. Mapping Targets in the Hadoop Environment
  6. Mapping Transformations in the Hadoop Environment
  7. Processing Hierarchical Data on the Spark Engine
  8. Configuring Transformations to Process Hierarchical Data
  9. Processing Unstructured and Semi-structured Data with an Intelligent Structure Model
  10. Stateful Computing on the Spark Engine
  11. Monitoring Mappings in the Hadoop Environment
  12. Mappings in the Native Environment
  13. Profiles
  14. Native Environment Optimization
  15. Cluster Workflows
  16. Connections
  17. Data Type Reference
  18. Function Reference
  19. Parameter Reference

Configure the Cluster to Use an External RDS as the Hive Metastore Database

Configure the Cluster to Use an External RDS as the Hive Metastore Database

If you want to use a relational database on the cloud platform as the Hive metastore database for the cluster, you must set cluster configuration properties in the Software Setting property of the Create Cluster task.
Configure the Create Cluster task to set configuration properties in the hive-site.xml configuration file on the cluster. Use a text file to specify hive-site settings, and specify the path to the file in the Software Settings property.
The following text shows sample configuration of the Software Settings property:
{ "Classification":"hive-site", "Properties":{ "javax.jdo.option.ConnectionURL":"jdbc:mysql:\/\/<RDS_HOST>:<PORT>\/<USER_SCHEMA>?createDatabaseIfNotExist=true", "javax.jdo.option.ConnectionDriverName":"<JDBC driver name>", "javax.jdo.option.ConnectionUserName":"<USER>", "javax.jdo.option.ConnectionPassword":"<USER>" } }
Example:
Example: { "Classification":"hive-site", "Properties":{ "javax.jdo.option.ConnectionURL":"jdbc:mysql:\/\/<host name>:<port number>\/hive?createDatabaseIfNotExist=true", "javax.jdo.option.ConnectionDriverName":"org.mariadb.jdbc.Driver", "javax.jdo.option.ConnectionUserName":"hive", "javax.jdo.option.ConnectionPassword":"hive" } }

hive-site

javax.jdo.option.ConnectionURL
JDBC connection string for the data store.
javax.jdo.option.ConnectionDriverName
JDBC driver class name for the data store. Specify a JDBC driver that is compatible with the cloud platform.
javax.jdo.option.ConnectionUserName
User name to use to connect to the database.
javax.jdo.option.ConnectionPassword
Password for the database user account.


Updated October 23, 2019