jdbc resultset hive 取多少数据

2025-04-18 18:43:39
推荐回答(1个)
回答1:

select orderid,fenjian,timeefrom ( select orderid,fenjian,timee,row_number(orderid,fenjian) rn from ( select orderid,fenjian,timee from tableName distribute by orderid,fenjian sort by orderid,fenjian,timee asc ) t1) t2where t2.rn=1