create table score(
name string,
subject string,
score int)
row format delimited fields terminated by "\t";
load data local inpath '/home/hadoop/data/score.txt' into table score;
6)按需求查询数据
select
name,
subject,
score,
rank() over(partition by subject order by score desc ) rk,
dense_rank() over(partition by subject order by score desc ) drk ,
row_number() over(partition by subject order by score desc ) rn
from
score;