3511095 - "CREATE STATISTICS ON .." fails - CDI adapter - Smart Data Integration (SDI)

Trying to create statistics for a virtual table in a CDI adapter related scenario

• Error in UI:
  Could not execute 'CREATE STATISTICS ON<Virtual table>' in xx seconds. 
• Error in framework trace:
  SAP DBTech JDBC: error building data statistics object: Error opening the cursor for the remote database Error occurred when reading data from entitySet [<SAC_data_model>]: The aggregate COUNT function is not supported! for query "SELECT COUNT(*)" FROM "<SAC_data_model>" "<Virtual table>" GROUP BY "<Virtual table>"."<Field>" ORDER BY "<Virtual table>"."<Field>" ASC": line 0 col 0 (at pos 0)
• Error in indexserver trace:
  <Date-time> e DPAdapterManager AdapterManager.cpp(04549) : ::sendMessage: Error occurred when reading data from entitySet [<SAC_data_model>]: The aggregate COUNT function is not supported!

CDI adapter, count, aggregation, group by, order by , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem