hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <jamalrai...@gmail.com>
Subject Re: how to do random sampling in hive?
Date Tue, 14 Aug 2012 22:23:26 GMT
I think you can use here LIMIT-

Limit indicates the number of rows to be returned. The rows returned are
chosen at random. The following query returns 5 rows from t1 at random.



SELECT * FROM t1 LIMIT 5

http://karmasphere.com/hive-queries-on-table-data



*Raihan Jamal*



On Tue, Aug 14, 2012 at 3:18 PM, zuohua zhang <zuohua@gmail.com> wrote:

> Would like to extract a uniform random sample from a hive table? How
> should I write the query?
> Thanks!
>

Mime
View raw message