Queries may become stalled in the Pivotal HDB engine because of a defect in the Pivotal optimizer.
Support for Pivotal HDB was added in IBM Cognos Analytics version 11.0.5.
Resolving The Problem
The Pivotal administrator can change the server defaults or add the following command block for the connection in IBM Cognos Administration.
If a table was created in HDB with partitioning, the Pivotal JDBC driver returns metadata for each partition of the table. Currently, there is no means in the Pivotal software to prevent it from returning the extra metadata. A modeler in Cognos Analytics does not have to include that additional metadata for queries to work.
Was this topic helpful?
15 June 2018