Hibernate Community • View topic - Is Rank() over partition supported in hql query?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Is Rank() over partition supported in hql query?

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

Sivam

Post subject: Is Rank() over partition supported in hql query?

Posted: Wed Apr 10, 2013 4:30 am

Newbie

Joined: Wed Apr 10, 2013 4:25 am
Posts: 4

Is Rank() over partition supported in hql query?. If not what is the equivalant function in HQL? I am not able to get valid answers from google results.

Top

pb00067

Post subject: Re: Is Rank() over partition supported in hql query?

Posted: Thu Apr 11, 2013 9:30 am

Expert

Joined: Tue Jun 16, 2009 3:36 am
Posts: 990

I fear not.
Rank over partition seems to be a special feature of SQLServer not common to other databases,
that's maybe the reason why it did not make into HQL.

Top

Sivam

Post subject: Re: Is Rank() over partition supported in hql query?

Posted: Mon Apr 15, 2013 6:44 am

Newbie

Joined: Wed Apr 10, 2013 4:25 am
Posts: 4

Thanks for the clarification.In hibernate createSqlquery RANK() over partition is working fine, but i want to use it in HQL. Is there any alternate?

Top

pb00067

Post subject: Re: Is Rank() over partition supported in hql query?

Posted: Thu Apr 18, 2013 3:20 am

Expert

Joined: Tue Jun 16, 2009 3:36 am
Posts: 990

I think using createSqlQuery is the best way.
The purpose using HQL instead to native SqlQuery is getting database independence.
I you rely on using RANK() over partition then you are tied to SQLServer anyway.

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum