hive hql错误：not yet supported place for udaf 'max'你不能嵌套聚合函数 , 你可能想要两层聚合:
select count(*), url from tokenized_access_logswhere url like '%\/product\/%'group by urlorder by count(*); the error showed is: Error while compiling statement: FAILED: SemanticException [Error 10128]: Line 4:9 Not yet supported place for UDAF 'count'Reply...
hive>SELECTcol1,>count(*)ascnt>fromtable_name>groupby col1>order bycount(*)desc>;FAILED:SemanticException[Error10128]:Line5:9Notyet supported placeforUDAF'count'hive> 二. 解决方案 大概是在Oracle MySQL上写SQL写习惯了,以为可以这么写。 出了问题也是不知道从何排查 后面把order by子句注释掉之后,...