Hive sql随机读取数据抽样数据

普通的随机筛选100条数据

select
    *
from
    xxx
order by
    rand()
limit
    100

每个用户筛选几条数据

select
    *
from
    (
        select
            *,
            row_number() over(partition by mid order by rand() ) as rn
        from
            xxx
    ) a
where
    rn <= 10