If you cannot use Kerberos impersonation to authenticate and access the Hive service on a cluster, review the steps in the Pentaho Business Analytics document.
If this issue persists, copy the hive-site.xml file on the Hive server to the configuration directory of the named cluster connection in these directories: