要求根据员工的职级分类,然后每类职级随机抽取2条数据,
建表:
create table temp.a
(id string,
name string,
age string,
rank string
)
ROW format delimited FIELDS TERMINATED BY ',' ;
load data local inpath 'a.txt' into table temp.a;
select * from temp.a;
id | name | age | rank |
1 | a | 10 | p1 |
2 | b | 34 | p1 |
3 | c | 23 | p2 |
4 | d | 33 | p2 |
5 | e | 23 | p2 |
6 | f | 67 | p3 |
7 | g | 34 | p3 |
8 | h | 12 | p4 |
9 | i | 54 | p5 |