Re: hive query is very slow,why?

2013-07-19 Thread Nitin Pawar
Huang, the number of records are huge and we do not know what your table definition is or what your cluster capacity is? there are multiple reasons that query is slow Can you share all the details on 1) Whats your table definition? 2) Whats the cluster capacity? 3) when you launched query did the

hive query is very slow,why?

2013-07-18 Thread ch huang
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

Re: hive query is very slow,why?

2013-07-18 Thread Stephen Boesch
one mapper. how big is the table? 2013/7/18 ch huang justlo...@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