Try this: select * from table_name order by rand() limit 5;
Cheers, R On Tue, Aug 14, 2012 at 3:23 PM, Raihan Jamal <jamalrai...@gmail.com> wrote: > 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 <zuo...@gmail.com> wrote: > >> Would like to extract a uniform random sample from a hive table? How >> should I write the query? >> Thanks! >> > >
