hibernate - 如何在HQL中进行Union SQL语句？

Question

我正在尝试使用 HQL(Hibernate 查询语言)在两个表之间创建联合。这个 SQL 脚本在我的 SQL 服务器上运行良好:

SELECT COUNT(DISTINCT linkedin_id) as test, school_name
FROM
(SELECT * FROM alum_education 
 UNION
 SELECT * FROM alum_connection_educations) AS UNIONS where school_name='some string'

问题是，当我尝试像这样在 grails 中运行它时:

     def countOfEdu = AlumEducation.executeQuery("select count (distinct linkedinId ) as countOfEdu, schoolName as SchoolName from (SELECT * FROM alumEducation UNION SELECT * FROM alumConnectionEducations) AS UNIONS where schoolName='some string'" )

我收到此错误:

  org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 83 [select count(distinct linkedinId )  as countOfEdu, schoolName as SchoolName  from (SELECT * FROM alumEducation UNION SELECT * FROM alumConnectionEducations) AS UNIONS where schoolName='Duquesne University']

如何在 grails 中运行上面的 SQL 语句？

谢谢杰森

Answer 1

HQL 不支持联合。有一个issue在自 2005 年开放的 Hibernate JIRA 中。