select sum(metric) from table. The broker will split the query into 2 queries based on this time boundary - one for offline and one for realtime. This query becomes -
select sum(metric) from table_REALTIME where date >= Mar 25and
select sum(metric) from table_OFFLINE where date < Mar 25The broker then merges results from both these queries before returning back to the client.