Hi, I'm trying to use PowerBI to analyze my Hive data. But when I'm connecting to Hive by using ODBC, I can see all databases even if I don't have right permissions for other databases. These are the databases I have permissions in Ranger.   This is a PowerBi screenshot when I connected Hive by using ODBC. As you can see above, I can see all databases.   This is a ODBC setting for connecting to Hive.   But if I connect to Hive by using HiveLLAP, I can  see right databases like below.   So question is Why can I see all hive databases without permissions when I connected to Hive by using ODBC.   If anyone knows the reason, please let me know. I would really appreciate it.   Thanks.     ... View more

Hi I'm wondering why the users are not mapped to the AD group as shown below. These are my configurations in Ranger.   * COMMON CONFIGS LDAP/AD URL : ldap://myADIp:389 Bind User: cn=admin,ou=ou1,dc=dc1,dc=dc2,dc=dc3 Incremental Sync: Yes Enable LDAP STARTTLS: No   * USER CONFIGS Username Attribute: sAMAccountName User Object Class: user User Search Base: ou=ou1,dc=dc1,dc=dc2,dc=dc3 User Search Filter: (empty) User Search Scope: sub User Group Name Attribute: memberof,ismemberof Group User Map Sync: Yes   * GROUP CONFIGS Group Member Attribute: member Group Name Attribute: cn Group Object Class: group Group Search Base: ou=ou1,dc=dc1,dc=dc2,dc=dc3 Group Search Filter: (empty) Enable Group Search First: No Sync nested Groups: No     I would appreciate if you answer to me about this. Thanks.   ... View more