Administrator Guide

9.9
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Configuring the Hive Database for ZooKeeper on the Dynamic Data Masking Server

From the Management Console, click

Tree

Add Database

The

Add Database

window appears.

Select

Hive

as the database type.

In the

DDM Database Name

field, enter the name of the Dynamic Data Masking database.

Example:

hive2_serv

In the

Driver Classpath

field, enter the absolute path of each driver.

Example:

C:\hive_jdbc_driver\*"

Verify that the folder for each driver contains the required jar files.

For example, the Hortonworks distribution Hive driver must contain the following files:

hadoop-auth-xxx.jar

hadoop-common-xxx.jar

hive-jdbc-xxx-standalone.jar

zookeeper-xxx.jar

commons-collections-xxx.jar

commons-configurationxxx.jar

commons-lang-xxx.jar

guava-xxx.jar

slf4j-api-xxx.jar

slf4j-log4jxxx.jar

In the

Driver Class Name

field, enter the fully qualified class name of the Hive driver.

Example:

org.apache.hive.jdbc.HiveDriver

In the

Connection String (URL)

field, enter the JDBC connection URL based on the driver.

If the Hive database is Kerberos-enabled, the URL must include the

auth

and

kerberosAuthType

properties.

jdbc:hive2://<zookeeper_ensemble>/<databaseName>;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=<hive_cluster>;auth=kerberos;kerberosAuthType=fromSubject

Example:

jdbc:hive2://server1.informatica.com:2181,server2.informatica.com: 2181,server3.informatica.com:2181/hiveDatabase;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;auth=kerberos;kerberosAuthType=fromSubject

If you do not provide the databaseName, Dynamic Data Masking connects to the default Hive database.

For Kerberos-enabled Hive databases, because of the Hive driver bug

HIVE-15177

, the Dynamic Data Masking server cannot resolve _HOST in the Hive node URL of the hiveserver2 namespace. To resolve this issue, replace the _HOST value of the property

hive.server2.authentication.kerberos.principal=hive/_HOST@KERB

with the Hive server hostname in the Hive configuration.

After you replace the _HOST value, the property value appears as:

_HOST hive.server2.authentication.kerberos.principal=hive/your.host.com@KERB

In the

Database Server Principal

field, specify the server principal of Hive.

Example:

hive/hiverserver@REALM.COM

Do not enter a value in the

DBA Username

and

DBA Password

fields.

Click

Test Connection

A JDBC connection to the Dynamic Data Masking service opens. The services uses the defined database connection parameters. A confirmation message appears if the connection is valid.

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Configuring the Hive Database for ZooKeeper on the Dynamic Data Masking Server

Configuring the Hive Database for ZooKeeper on the Dynamic Data Masking Server