If you are unable to create a new account, please email support@bspsoftware.com

 

Impala Connection String for Cognos Analytics 11.1

Started by Eugene, 12 Jul 2019 07:24:14 AM

Previous topic - Next topic

Eugene

I want to connect Cognos Analytics  11.1 with Cloudera Impala.
The connection string that I have used  so far is :
jdbc:impala://host:port/<schema name>. Also the jdbc that I used at cognos is Simba JDBC Driver for Impala.

My question is , I want to to see tables from different schemas. How is this possible, when I put the name of a certain schema into the connection string?

I am wondering if there is an error at connection string due to the fact that when i run a report from a package which is read Impala I am taking the following error

Data source adapter error: java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: java.net.SocketException: Software caused connection abort: : socket write error, SQL state: HY000