Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB