Page tree
Skip to end of metadata
Go to start of metadata

The following query shows a limited set of statistics for SDI queries involving the ODataAdapter. Confirm your filters, column projections, paging and historical dating parameters, and any other important specifications are being applied by reviewing the full REMOTE_STATEMENT_STRING column. If a $filter is not included in the REMOTE_STATEMENT_STRING, is there a difference in the values of RECEIVED_RECORD_COUNT and DELIVERED_RECORD_COUNT? If you see different values there, the filter couldn't be pushed down but HANA applied it on the final result set; check to ensure your filter values are defined with correct data types and try to limit usage of SQL functions in the filter.

ODataAdapter remote query statistics SQL
SELECT RQS.REMOTE_SOURCE_NAME, 
	ACCESSED_VIRTUAL_TABLE_NAMES, 
	REMOTE_STATEMENT_STRING, 
	REMOTE_STATEMENT_STATUS, 
	RECEIVED_RECORD_COUNT, 
	DELIVERED_RECORD_COUNT, 
	START_TIME, 
	END_TIME
FROM M_REMOTE_QUERY_STATISTICS AS RQS
	INNER JOIN REMOTE_SOURCES AS RS
	ON RQS.REMOTE_SOURCE_NAME = RS.REMOTE_SOURCE_NAME
		AND RS.ADAPTER_NAME = 'ODataAdapter'
ORDER BY START_TIME DESC;