When Hive uses LDAP authentication in a cluster that does not use Kerberos authentication, consider the following guidelines:
To access Hive metadata and preview Hive data, you can configure Big Data Management to use LDAP credentials. In the Hive connection, set the user name and password properties for the LDAP user.
To run mappings in the Hadoop environment, set the impersonation user name in the Hadoop connection as the Hive user.
If the Data Integration Service uses operating system profiles, set the user name of the operating system profile as the Hive user.