Hive Connection
Create an Hive connection to write data to a Hive table.
You can create and manage a Hive connection in the Developer tool or through infacmd.
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.