hive获取历史静默商户余额，半笛卡尔积_hive 每天的余额怎么

实现：

select
n.date,n.id,n.money
from
(
 select
 ROW_NUMBER() OVER(PARTITION BY m.date,m.id ORDER BY m.date1 desc) AS rn 
 m.date,m.id,m.money
 from (
 select 
 dim.date,table.date as date1,dim.id,table.money
 from dim,table
 where dim.date>=table.date and dim.id=table.id
 ) m 
) n
where n.rn=1 and m.money>0

题解：

20200801 20200801 1  1000
20200802 20200801 1  1000
20200802 20200802 1  2000
20200803 20200801 1  1000
20200803 20200802 1  2000
20200804 20200801 1  1000
20200804 20200802 1  2000
20200805 20200801 1  1000
20200805 20200802 1  2000
20200805 20200805 1  5000