oracle AND ROWNUM=1用法转成hives sql

使用

ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY user_id desc) as row_num  -- 新字段

where row_num=1;