hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olga Natkovich (JIRA)" <j...@apache.org>
Subject [jira] Commented: (PIG-795) Command that selects a random sample of the rows, similar to LIMIT
Date Sun, 03 May 2009 02:24:30 GMT

    [ https://issues.apache.org/jira/browse/PIG-795?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12705368#action_12705368

Olga Natkovich commented on PIG-795:

I tested the patch and it works very well. Thanks Eric for contributing!

We are trying to commit multiquery changes at the moment. I will commit this patch in a day
or two once the multiquery code is in.

> Command that selects a random sample of the rows, similar to LIMIT
> ------------------------------------------------------------------
>                 Key: PIG-795
>                 URL: https://issues.apache.org/jira/browse/PIG-795
>             Project: Pig
>          Issue Type: New Feature
>          Components: impl
>            Reporter: Eric Gaudet
>            Priority: Trivial
>         Attachments: sample2.diff, sample3.diff
> When working with very large data sets (imagine that!), running a pig script can take
time. It may be useful to run on a small subset of the data in some situations (eg: debugging
/ testing, or to get fast results even if less accurate.) 
> The command "LIMIT N" selects the first N rows of the data, but these are not necessarily
randomzed. A command "SAMPLE X" would retain the row only with the probability x%.
> Note: it is possible to implement this feature with FILTER BY and an UDF, but so is LIMIT,
and limit is built-in.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message