I have problem running SQL quires from Cognos 11 to impala. I can see the SQL generated in Cognos contain the catalog name, the shema name and the table name in the FROM part in SQL.
Whan I run the sql in HUE I get an error, but after removing the catalogname(impala.) the SQL runs fine. I run on the lastes jdbc driver 2.5.31 and the cloudera 5.7 demo image. Any tips on how to make cognos remove the catalogname or accept the catalogname in the SQL?
It is a defect in the Simba devloped driver which is supposed to be addressed in the next (post 2.5.32) driver update.
Get Cloudera suppor to confirm what the ETA is for the drive to be released.
Persons using Framework Manager can go into the data source object in the FM UI and remove the catalog name "Impala" which the Simba driver returns via the various DatabaseMetadata methods to describe tables, columns etc.