https://userapps.support.sap.com/sap/support/knowledge/en/3314753
3314753 - Select count(*) is not pushed down to ODQ - SAP HANA Smart Data Integration | SAP...
Execute "select count(*)" through a virtual table to CDS view through ABAPAdatper From ODQMON, it is selecting all the records from source