Troubleshooting
Problem
When attempting to establish a connection from the Cognos BI server to a Hive version 0.9 data source (this is the version of Hive included in BigInsights 2.0), the following error is returned:
XQE-DS-006 Unable to logon to the data source.
Could not establish connection to
Cause
A Hive server with authentication enabled will reject connections if you do not have a file called hive-site.xml along your class path which it uses during a connection. This file can be defined with properties that reflect how security is set up on the Hive server.
Resolving The Problem
Create a file called hive-site.xml with the entries below in it and copy it to the ..\webapps\p2pd\WEB-INF\classes directory of the Cognos BI server.
<configuration>
<property>
<name>hive.security.authentication</name>
<value>password</value>
</property>
</configuration>
Restart the Cognos BI server after making the hive-site.xml file available to it to allow connections to be established successfully with an Apache Hive 0.9 instance with authentication enabled.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21637053