Hive提取小时内，分组排名前3的sql

表的结构是这样的，时间的范围我是提取了几个小时内的数据

create table  `alibaba.user_bea` (
user_id  bigint,
    item_id bigint,
    cate_id bigint,
    times     string,
    bea      int
   
)
PARTITIONED BY (dt STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' 
STORED AS orc;

提取时间

select item_id,ranks from (Select item_id,