使用配置单元进行字数计算时出现问题。
我的Hive命令就像

select word, count(1) as count 
from (select explode(split(word, ' ' )) as word from note) w   
group by word 
order by count desc 
limit 5
;

结果：

the 20583
of  10388
     9479
and  7611
in   5226

9479是行数。我该怎么处理这个？