Unable to use impala as data server : XQE-DAT-0001

[petterhuseby]

Hi

I have created datamodule and used Clodera impala as a datasurce. Im able to create and save the module, but when I create a new dashboard with this modul I get the attached error message XQE-DAT-0001. Saying could not resolve the table reference. When I look at the query on the Impala server I see that the table name in the query is in this format: impala.default.hub_kusk.

When this query runs ok if I remove the forst part: impala. So it seems that the problem is the SQL cognos og the JDBC driver is sending to the impala server.

Any tips for solving this ?

Br

Petter

[petterhuseby]

Just like to add that the module I have created works perfect in the new repoert studio. So the problem is using the module on the new Dashboards.

Here is the SQL from report studio:
SELECT `dim_hest_par`.`hestens_navn` as `Hestens_Navn`
FROM `default`.`dim_hest_par` `dim_hest_par`

her is the SQL from Dashboard
SELECT `dim_hest_par`.`hestens_navn` AS `C`
FROM `Impala`.`default`.`dim_hest_par` `dim_hest_par`

You can see that `Impala` is added in the Dashboard query and it will not run on the impala server.

Br
Petter

[MFGF]

Just like to add that the module I have created works perfect in the new repoert studio. So the problem is the using the module on the new Dashboards.

Here is the SQL from report studio:
SELECT `dim_hest_par`.`hestens_navn` as `Hestens_Navn`
FROM `default`.`dim_hest_par` `dim_hest_par`

her is the SQL from Dashboard
SELECT `dim_hest_par`.`hestens_navn` AS `C`
FROM `Impala`.`default`.`dim_hest_par` `dim_hest_par`

You can see that `Impala` is added in the Dashboard query and it will not run on the impala server.

Br
Petter

Hmmm. I think that might be one to log with IBM. :)

MF.

[the6campbells]

Cloudera JDBC driver for Impala has several defects in driver versions earlier than 2.5.31.

One of the defects fixed in 2.5.31 includes when the Cloudera JDBC driver returns Impala as the catalog name but the driver fails to parse a qualified object name which includes the catalog name.

Upgrade the driver
https://www.cloudera.com/documentation/other/connectors/impala-jdbc/latest.html

[petterhuseby]

Hi

I have now testet the latest jdbc driver on the latest impala vmware image(5.7) and the lastest cognos 11.0.2.  I sees that framework manager works ok, if you clear the catalog field in the datasource connection. But Im not able to create new dataservers in the web page and create new datamodels. The catalog name is still in the SQL and Impala is not able to execute the query. In the SQL I still see this : .... FROM `Impala`.`default`.....

Anyone who has manage to use Impala in Cognos 11 ?

Br
Petter