SAS connection issue with hive2

[#1]

Hi,

Encountered below error while connecting to hive2 using SAS,

ERROR: Unable to connect to the Hive server.

ERROR: Error trying to establish connection.

ERROR: Error in the LIBNAME statement.

 Same user can connect to hive but to different schema.

[#2 · Accepted solution]

There were permission issue with Centrify where users permissions were masked with ACL like method.

[#3]

Congratulations on solving your issue and thanks for sharing it.