hive null值排序

create table udl.zgc_0903_test
(
    name          string,
    money         string,
    update_time   string
);
insert into table udl.zgc_0903_test values
('AAA','200','2020-01-01 12:00:00')
,('AAA','260','2020-02-01 12:00:00')
,('BBB','100','2020-01-01 12:00:00')
,('BBB',NULL,'2020-02-01 12:00:00')
,('BBB',NULL,NULL)
,('CCC','300',NULL)
,('CCC','400',NULL)
,('DDD','100',NULL)
,('DDD','250','2020-02-01 12:00:00');
,(NULL,'260','2020-02-01 12:00:00')
,(NULL,'100','2020-01-01 12:00:00');

查询 ：

select *,row_number()over(partition by name order by update_time desc) rn from udl.zgc_0903_test;

结论：null值排序会排到最后