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
On Tue, Aug 14, 2012 at 3:18 PM, zuohua zhang <[EMAIL PROTECTED]> wrote:
> Would like to extract a uniform random sample from a hive table? How
> should I write the query?