User Guide

10.2.2
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 Service Pack 1
- 10.2.1

Back Next

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

Rename Saved Search

Table of Contents

User Guide

User Guide

Creating a Hive Connection using Informatica Command Line Program

Creating a Hive Connection using Informatica Command Line Program