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
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.