Table of Contents


  1. Preface
  2. Introduction to Big Data Streaming
  3. Big Data Streaming Administration
  4. Sources in a Streaming Mapping
  5. Targets in a Streaming Mapping
  6. Streaming Mappings
  7. Window Transformation
  8. Appendix A: Connections
  9. Appendix B: Sample Files

Creating a Hive Connection using Informatica Command Line Program

Creating a Hive Connection using Informatica Command Line Program

You can use the
command line program to create a Hive connection. Access the command from the
<Informatica installation directory>/clients/DeveloperClient/infacmd
On UNIX, run the following command:
sh createConnection
On Windows, run the following command:
infacmd.bat createConnection
Enter connection options in the following format:
... -o option_name='value' option_name='value' ...
For example, run the following command to create a Hive connection on UNIX:
sh CreateConnection -dn <domain name> -un <domain user> -pd <domain password> -cn <connection name> -cid <connection id> -ct HIVE -o "CLUSTERCONFIGID='ConfId' metaDataConnString='jdbc:hive2://<hostname>:<port>/<db>' enableQuotes='false' HIVEWAREHOUSEDIRECTORYONHDFS='/user/hive/warehouse' DATABASENAME='default' BYPASSHIVEJDBCSERVER='false' ConnectString='jdbc:hive2://<hostname>:<port>/<db> databaseName=default defaultFSURI= hdfs://<node name>:<port>'"
For more information about the CreateConnection command and Hive connection options, see the
Informatica Command Reference Guide


We’d like to hear from you!