hadoop - Hive 查询在 0.13 中挂起

Question

我有 12GB 的表数据。

我的表如下所示:

userid name score
1      abc   1
1      pqr   1
2      mno   1
2      pqr   1
.
.
.
750000 mno   1 

这是我的查询:

select a.userid as user1,b.userid as user2, sum(a.score*b.score) as score,count(distinct a.name) as distinct_name from table a join table b on(a.name=b.name) limit 10;

它运行了几个小时，但没有返回任何结果。我怎样才能解决这个问题？

Answer 1

试试这个，

select a.userid as user1,b.userid as user2, sum(a.score*b.score) as score,count(distinct a.name) as distinct_name 
from table a join table b on(a.name=b.name)
group by a.userid , b.userid
limit 10;

把你的 table 名放在 table 上；