java - hibernate 状态下的 Postgresql 'select distinct on'

Question

hibernate 是否支持 select distinct on 查询？

SELECT DISTINCT ON (location) location, time, report
FROM weather_reports
ORDER BY location, time DESC;

有没有办法为该查询创建 hibernate 条件？

Answer 1

既然这里全是“怀疑”和“猜测”，所以当我遇到这个问题时，我会肯定地回答:

不，Hibernate 不支持 DISTINCT ON 查询。

org.hibernate.hql.internal.ast.QuerySyntaxException: 
unexpected token: ON near line 1, column 17
[SELECT DISTINCT ON (location) location, time, report FROM weather_reports ORDER BY location, time DESC]

在 Hibernate 4.3.9-final 下测试

请注意，这不适用于普通的 DISTINCT 查询。参见 https://stackoverflow.com/questions/263850...