Cognos and impala

[petterhuseby]

I currently testing Cloudera Impala as a data source for Cognos.  I able to create the data source and get the subject quires to test ok. But when I create a regular dimension an error occurs: XQE-GEN-0018 Query Service internal error has occurred, please see the log for details
Here is the SQL that Cognos generate:
(SELECT `d_bomstasjoner_par`.`bomstasjon_navn` AS `column0`
FROM    `Impala`.`default`.`d_bomstasjoner_par` `d_bomstasjoner_par`
GROUP BY     `d_bomstasjoner_par`.`bomstasjon_navn`
ORDER BY     `d_bomstasjoner_par`.`bomstasjon_navn` ASC NULLS LAST)

I have tested this sql directly on impala and it work ok, so this is very strange. Has someone else in this forum created DRM models on Hadoop/hive/impala?

Br
Petter

[petterhuseby]

I can see the following SQL in impala side:

SELECT
    `d_bomstasjoner_par`.`bomstasjon_navn` AS `column0`
FROM
    `Impala`.`default`.`d_bomstasjoner_par` `d_bomstasjoner_par`
GROUP BY
    `d_bomstasjoner_par`.`bomstasjon_navn`
ORDER BY
    `d_bomstasjoner_par`.`bomstasjon_navn` ASC NULLS LAST


If I remove the following from the FROM part : `Impala`.`default`.`d_bomstasjoner_par it work fine. So it's seems that Cognos add to many values in the from PART. is it any way to controll this?

[petterhuseby]

I manage to solve the problem. I just needed to remove the value from catalog field in from the data source. it was set to Impala.

[MFGF]

I can see the following SQL in impala side:

SELECT
    `d_bomstasjoner_par`.`bomstasjon_navn` AS `column0`
FROM
    `Impala`.`default`.`d_bomstasjoner_par` `d_bomstasjoner_par`
GROUP BY
    `d_bomstasjoner_par`.`bomstasjon_navn`
ORDER BY
    `d_bomstasjoner_par`.`bomstasjon_navn` ASC NULLS LAST


If I remove the following from the FROM part : `Impala`.`default`.`d_bomstasjoner_par it work fine. So it's seems that Cognos add to many values in the from PART. is it any way to controll this?

Hi,

If you select your data source in Framework Manager and look at the properties, you will probably see a catalog setting of "Impala" and a schema setting of "default"? Try removing the catalog name.

Cheers!

MF.

[MFGF]

I manage to solve the problem. I just needed to remove the value from catalog field in from the data source. it was set to Impala.

Ahhh. I was just too late. You found it already. Good work! :)

MF.

[petterhuseby]

Hi

The regular dimensions work after removing the catalog value, but the query subject is not able to validate. 

Is it possible to add the catalog just to the query subjects?

Always some trouble....

[petterhuseby]

Hi

During my troubleshoting a older impala driver was installed. I updatet it and everything work fine now after just removing the catalog value.

BR
Petter