hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ch huang <justlo...@gmail.com>
Subject Re: hive query is very slow,why?
Date Fri, 19 Jul 2013 02:08:57 GMT
the table records are more than 120000000

On Fri, Jul 19, 2013 at 9:34 AM, Stephen Boesch <javadba@gmail.com> wrote:

> one mapper.  how big is the table?
>
>
> 2013/7/18 ch huang <justlooks@gmail.com>
>
>> i wait long time,no result ,why hive is so slow?
>>
>> hive> select cookie,url,ip,source,vsid,token,residence,edate from
>> hb_cookie_history where edate>='1371398400500' and edate<='1371400200500';
>> Total MapReduce jobs = 1
>> Launching Job 1 out of 1
>> Number of reduce tasks is set to 0 since there's no reduce operator
>> Starting Job = job_1374138311742_0007, Tracking URL =
>> http://CH22:8088/proxy/application_1374138311742_0007/<http://ch22:8088/proxy/application_1374138311742_0007/>
>> Kill Command = /usr/lib/hadoop/bin/hadoop job  -kill
>> job_1374138311742_0007
>>
>
>

Mime
View raw message