Postgres DISTINCT ON eqivalent in Hibernate Query Language

Question

I need Postgres DISTINCT ON equivalent in HQL. For example consider the following.

SELECT DISTINCT ON (Col2) Col1, Col4 FROM tablename;

on table

Col1 | Col2 | Col3 | Col4
---------------------------------
AA1  | A    |  2    | 1
AA2  | A    |  4    | 2
BB1  | B    |  2    | 3
BB2  | B    |  5    | 4

Col2 will not be shown in the result as below

Col1 | Col4
------------
AA1  |  1
BB1  |  3

Can anyone give a solution in HQL. I need to use DISTINCT as it is part of a bigger query.

score 2 · Accepted Answer · edited May 23 '17 at 12:15

2

Sorry but I misread your question:

No, Hibernate does not support a DISTINCT ON query.

Here is possible duplicate of your question: Postgresql 'select distinct on' in hibernate

edited May 23 '17 at 12:15

Community

1
1

answered Sep 16 '16 at 08:58

jarvo69

7,908
2
18
28

What is the SQL generated for that? – Sep 16 '16 at 09:07
Thanks for the answer, I can't use Criteria for some reasons. I need query (HQL). – Khaino Sep 16 '16 at 09:16

Postgres DISTINCT ON eqivalent in Hibernate Query Language

1 Answers1