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! >
