为了解决这个问题，您需要一个列，可以用来对记录进行排序。我假设这样一个列和 id .
在 hive 里，你可以用 row_number() 做个Windows sum() 具体如下：

select
    name,
    num,
    sum(case when rn = 1 then 1 else num) over(partition by name order by id) derived
from (
    select
        t.*,
        row_number() over(partition by name order by id) rn
    from mytable t
) t

可以使用会话变量

select
  z.name as name,
  z.num as num,       
  @derived := case
  when z.row_num='1' then '1'
  else num + @derived
  end as derived
from
  (select name,num,row_number() over(partition by name order by name) as row_num
  from result)z,(SELECT @derived:= 0) d1

这会给你

name | num | derived
:--- | --: | :------
A    |   0 | 1      
A    |   1 | 2      
A    |   0 | 2      
B    |   0 | 1      
B    |   0 | 1      
B    |   1 | 2      
C    |   0 | 1      
C    |   0 | 1      
D    |   1 | 1      
D    |   1 | 2      
D    |   1 | 3

db<>在这里摆弄