I want to run a query like below to solve the problem in all streaming fashion
select sum(amount) from (select amount, max(my_timestamp) from table group by id, window("my_timestamp", "1 hours"))
just want the output to be
I am trying to find a solution without using flatMapGroupWithState or order by. I am using spark 2.3.1 (custom built from master) and I had already tried self join solution but again I am running into "multiple aggregations are not supported"