hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 韶隆吴 <yechen1...@gmail.com>
Subject hive is slow?
Date Thu, 15 Mar 2012 10:32:58 GMT
Hi all:
  I have two tables from hbase:orders(id bigint, total map<string,double>)
 ,orderitem(orderid bigint, productid map<string,bigint>)
and both table have more than 600000 rows.
  Now I scripts the HiveQL:select size(i.productid) from orders o join
orderitem i where o.id=i.orderid;
and it cost 426s.
 BTW.the hadoop cluster have 3 PC, I want to know where is the problem
happened.

Thanks.

Mime
View raw message