Hql group by unexpected AST node

如果按下面的格式写

则会抛如下的错误：

unexpected AST node: > near line 1, column 243 [SELECT CASE WHEN addTime> 1449555508 THEN Min(addTime) WHEN addTime< 1449555508 THEN MAX(addTime) END as addTime FROM BrandColumn WHERE addTime<> 1449555508 and type=2 GROUP BY addTime>1449555508]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected AST node: > near line 1, column 243 [SELECT CASE WHEN addTime> 1449555508 THEN Min(addTime) WHEN addTime< 1449555508 THEN MAX(addTime) END as addTime FROM BrandColumn WHERE addTime<> 1449555508 and type=2 GROUP BY addTime>1449555508]

经过查资料，才知道HQL里面的group by不能包含算数表达式

改成如下：

则正确了。

相关链接：http://blog.csdn.net/chenssy/article/details/7728367