大数据之hive+kylin

Row_Number()使用
通过Row_Number()实现获取最新的字段数据，本例中，对于每一个page_id+event_id+business_field_identifier我们获取最新一天（通过ORDER BY datekey DESC实现）的business_field_comment字段值。

select t_a.page_id,
       t_a.event_id,
       t_a.business_field_identifier,
       t_a.business_field_comment
  from (
        SELECT page_id,
               event_id,
               business_field_identifier,
               business_field_comment,
               Row_Number() OVER (PARTITION BY page_id, event_id, business_field_identifier ORDER BY datekey DESC) rank
          FROM dsnName.tableName
         where datekey between $now.delta(89).datekey and $now.datekey
       ) t_a
 where t_a.rank=1