Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> hive query is very slow,why?


Copy link to this message
-
Re: hive query is very slow,why?
the table records are more than 120000000

On Fri, Jul 19, 2013 at 9:34 AM, Stephen Boesch <[EMAIL PROTECTED]> wrote:

> one mapper.  how big is the table?
>
>
> 2013/7/18 ch huang <[EMAIL PROTECTED]>
>
>> 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
>>
>
>