Table of Contents

Search

  1. Preface
  2. Introduction to Intelligent Streaming
  3. Intelligent Streaming Configuration
  4. Connections
  5. Sources and Targets in a Streaming Mapping
  6. Intelligent Streaming Mappings
  7. Window Transformation
  8. Data Type Reference

Big Data Streaming User Guide

Big Data Streaming User Guide

Creating a Hive Connection using Informatica Command Line Program

Creating a Hive Connection using Informatica Command Line Program

You can use the
infacmd
command line program to create a Hive connection. Access the command from the
<Informatica installation directory>/clients/DeveloperClient/infacmd
directory.
On UNIX, run the following command:
sh infacmd.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 infacmd.sh CreateConnection -dn <domain name> -un <domain user> -pd <domain password> -cn <connection name> -cid <connection id> -ct HIVE -o "CLUSTERCONFIGID='ConfId' relationalSourceAndTarget='true' pushDownMode='false' 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
.