thanks a lot for the detailed problem description. This looks like a problem in the query flattener.
Can you please go to the Advanced tab of the DB Connector node and disable the “Flatten sub-queries where possible” option:
Thanks for the fast response. I have created a ticket for the problem (internal number AP-23850) and get back to you as soon as I know when we can fix this.
Bye
Tobias
Internal ticket ID: AP-23850 Summary: Query flattener creates invalid statement for SAP Hana if no aggregation column is used in the GroupBy node Fix version(s): 5.3.4, 5.4.1