LDAP with Hive issue - Unable to search for user in two different OU's

[#1]

Hi folks,

Currently using CDH 5.4.7. The idea is to get beeline authentication integrated with OpenLDAP.

This is working fine too. But only for a single OU.

Say I want hive to search in 2 ou's how do I do this?

I have currently set the following properties:

hive.server2.authentication.ldap.url

hive.server2.authentication.ldap.baseDN  - This is set to ou=people,dc=exampe,dc=com

Also I have added a snippet to be reflected on the hive-site.xml 

<property>
<name>hive.server2.authentication.ldap.userDNPattern</name>
<value>uid={0},ou=People,dc=example,dc=com:uid={0},ou=Service Accounts,dc=example,dc=com</value>
</property>

I have tried different combinations with uid=%s, uid={0}, specifying to the uid with the baseDN, but of no use.

Am i missing something here?

Thanks

[#2]

If the post above is not clear:
This is the summary:
User JohnDoe wants access to Hive.

The current OU is ou=people, but user John is a part of the ou=Service Accounts. Login is failing as hive is only looking at ou people. How can I add another ou in the properties, so that a search for the user is done.

Thanks.