.Hive: Given a table t with schema (date, revenue),

Question

6.Hive: Given a table t with schema (date, revenue), like this 6.Hive: Given a table t with schema (date, revenue), like this date r Jan. 1 100 Jan. 2 120 Jan. 3 80 Jan. 4 150 Jan. 5 50 What does the following query do? SELECT t1.date AS date, sum(t2.revenue) AS revenue FROM t as t1 JOIN t as t2 ON t2.date <= t1.date GROUP BY 1 ORDER BY 1