test

https://www.sunwei.info/15.html

SELECT  user_id
       ,MAX(request_time_ms) AS request_time_ms
       ,p_day
       ,p_hour
       ,p_type
FROM dw.test
WHERE p_day = '${day,-1 hour,yyyy-MM-dd}'
AND p_hour = '${day,-1 hour,HH}'
AND p_type = 'app'
AND action='VIEW_LIST'
GROUP BY  user_id
         ,p_day
         ,p_hour

https://www.sunwei.info/15.html