hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Newhaven <james.newha...@gmail.com>
Subject Re: Percentage of rows in a Hive Table
Date Wed, 28 Mar 2012 16:09:33 GMT
Thanks for the suggestion.

I don't think sampling helps here, as I need to get the top 5% of rows
ordered by a particular column (not a random sampling)



On Wed, Mar 28, 2012 at 5:03 PM, Gabi D <gabid33@gmail.com> wrote:

> James,
> See if sampling
> <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Sampling>is
> what you need
>
>
>
>
> On Wed, Mar 28, 2012 at 5:53 PM, James Newhaven <james.newhaven@gmail.com>wrote:
>
>> I am trying to write a query that will return the first 5% of rows in a
>> table.
>>
>> I've struggled with this for quite a while and can't figure out a command
>> that works in Hive.
>>
>> Has anyone done this?
>>
>> Thanks,
>> James
>>
>
>

Mime
View raw message