You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by ch huang <ju...@gmail.com> on 2013/08/19 05:16:48 UTC
question about get part result from hive
hi,all:
i have a problem ,i have a hive table ,it source data based on
HDFS,and i want to get part query result for processing(the whole data is
huge,so must
load partly),any good suggestions? (hive has no paging query result
function)
Re: question about get part result from hive
Posted by Stephen Sprague <sp...@gmail.com>.
Maybe its too obvious but there is the "limit" keyword as well.
On Sun, Aug 18, 2013 at 9:43 PM, Nitin Pawar <ni...@gmail.com>wrote:
> Hive does support sampling. Please look at
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Sampling
>
> We normally partition data based on few columns so we avoid these
> situations
>
>
> On Mon, Aug 19, 2013 at 8:46 AM, ch huang <ju...@gmail.com> wrote:
>
>> hi,all:
>> i have a problem ,i have a hive table ,it source data based on
>> HDFS,and i want to get part query result for processing(the whole data is
>> huge,so must
>> load partly),any good suggestions? (hive has no paging query result
>> function)
>>
>
>
>
> --
> Nitin Pawar
>
Re: question about get part result from hive
Posted by Nitin Pawar <ni...@gmail.com>.
Hive does support sampling. Please look at
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Sampling
We normally partition data based on few columns so we avoid these
situations
On Mon, Aug 19, 2013 at 8:46 AM, ch huang <ju...@gmail.com> wrote:
> hi,all:
> i have a problem ,i have a hive table ,it source data based on
> HDFS,and i want to get part query result for processing(the whole data is
> huge,so must
> load partly),any good suggestions? (hive has no paging query result
> function)
>
--
Nitin Pawar