Error opening the cursor for the remote database - group by not supported in select statement

[Syed_2]

Hi, when i execute a SQL query with group by clause over a virtual table (from success factors provisioned through SDA), I get the following error;

SAP DBTech JDBC: [403]: internal error: Error opening the cursor for the remote database Error parsing query: ERRORS <ERROR - group by is not supported in select statement

How do i get over this?

I'll appreciate any help.

[Subhendu]

Try to materialize/persist the remote table into HANA Cloud like-
Create table <tab_name> as selecr * from <Virtual_table>;
now you can use the group by clause in top of this newly created <tab_name>