You cannot use a PowerExchange for Hive connection if you want the Hive driver to run mappings in the Hadoop cluster. To use the Hive driver to run mappings in the Hadoop cluster, use a Hadoop connection.

The following properties are removed from the connection and imported into the cluster configuration:

Property	Description
Default FS URI	The URI to access the default Hadoop Distributed File System.
JobTracker/Yarn Resource Manager URI	The service within Hadoop that submits the MapReduce tasks to specific nodes in the cluster.
Hive Warehouse Directory on HDFS	The absolute HDFS file path of the default database for the warehouse that is local to the cluster.
Metastore Execution Mode	Controls whether to connect to a remote metastore or a local metastore.
Metastore Database URI	The JDBC connection URI used to access the data store in a local metastore setup.
Metastore Database Driver	Driver class name for the JDBC data store.
Metastore Database User Name	The metastore database user name.
Metastore Database Password	The password for the metastore user name.
Remote Metastore URI	The metastore URI used to access metadata in a remote metastore setup. This property is imported into the cluster configuration as the property hive.metastore.uris .