SAP HANA: "DB Table Selector" + With Custom Query and join fails with Flatten sub-queries enabled

[tescnovonesis]

Hi KNIME,

We have been through a month-long migration from Server to Hub.
Everything goes well, but our users keep finding funny issues here and there.

We have this settings in DB Connector

If a user, uses “DB Table Selector” + “Custom Query” + join, then the node fails.

If there is no join, or if we disable “Flatten sub-queries”, then it works:

But then for other straight DB Table Selectors

SQL instead get nested

Instead of simple

We could advice/promote templates that disable “Flatten sub-queries”.

But, we have some helper component nodes, that help build HANA SQL.

[tescnovonesis]

This issue seems similar:
SAP HANA: “DB GroupBy” fails - when no aggregation - KNIME Business Hub - KNIME Community Forum

[NDekay]

Hello @tescnovonesis ,

The thread you linked mentions fixes as of 5.3.4 and 5.4.1 - what version of AP are you currently using?

Regards,
Nickolaus

[tescnovonesis]

Hi,
I use 5.4.3

SELECT baoc.VIEW_NAME, baoc.DESCRIPTION, bdv.COLUMN_NAME, bdv.COLUMN_CAPTION
FROM "_SYS_BI".BIMC_DIMENSION_VIEW bdv 
JOIN "_SYS_BI".BIMC_AUTH_ONLY_CUBES baoc ON bdv.CATALOG_NAME=baoc.CATALOG_NAME

Br

[dora_gcs]

Hello @tescnovonesis ,

Thank you for reporting this behavior. We opened a dev ticket for fixing this, its internal number is AP-24272 (please note this is subject of change).

Sorry for the inconvenience and thanks again for your valuable feedback.

Cheers,