Table of Contents


  1. Preface
  2. Part 1: Version 10.4.0
  3. Part 2: Version 10.2.2
  4. Part 3: Version 10.2.1
  5. Part 4: Version 10.2
  6. Part 5: Version 10.1.1
  7. Part 6: Version 10.1

Hive Connection Properties

Hive Connection Properties

Effective in version 10.2, PowerExchange for Hive has the following changes:
  • 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:
    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


We’d like to hear from you!