IBM Support

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

Technote (troubleshooting)


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: Read time out


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.


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.

Document information

More support for: Cognos Business Intelligence

Software version: 10.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: All Editions

Reference #: 1637053

Modified date: 14 May 2013

Translate this page: