XQE-DS-0006 error when testing connection to Hive data source

Technote (troubleshooting)


Problem(Abstract)

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 <host>:<port>/default: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read time out

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.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence

Software version:

10.2

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1637053

Modified date:

2013-05-10

Translate my page

Machine Translation

Content navigation