Cloudera Impala 之 ORDER BY without LIMIT currently not supported

ERROR: NotImplementedException: ORDER BY without LIMIT currently not supported

 

impala中order by 需要limit的限制才可以运行，否则报错，可以通过limit一个很大的值来查看所有的数据，另外limit不支持 limit  a,b这种格式。

select ip,count(1) as cnt from cdnlog.dd_log group by ip order by cnt desc limit 100000000;