hivesql我习惯加limit,防止意外显示超多行。有时候group by+limit会少数,实际上没有60行,但是加了limit60得到的数比不加少很多,行数也显示不全,有人知道怎么回事吗?代码如下:
select
field1,field2,count(1)
from
(
select
field1,field2,field3
from table_temp
where field1 in('xxx','xxx')
and field2 in('xxx','xxx')
group by field1,field2,field3
) as data
group by field1,field2
limit 60;
补充一下结果
不加limit60:
加limit60: