【Hive】order by count() 报错

order by count(id) 报错

hive> select date, count(id) as idnum from test group by date order by count(id)
FAILED:SemanticException[Error 10004]:...Invalid table alias or column reference 'id':(possible column names are:...)

修改为( 用别名idnum替换count(id) )，没有报错

hive> select