Top "Hql" questions

Spring data jpa. Find max if no result return default value

I've implemented in my spring repository interface: @Query("SELECT max(ch.id) FROM MyEntity ch") Long getMaxId(); It works correctly …

java spring spring-data-jpa hql

org.hibernate.MappingException: entity class not found ( using qualified class name does not work)

I'm trying to run a simple SELECT FROM table ( I have also tried SELECT FROM package.Class )query but I …

orm hql hibernate-tools

Hibernate query: does a Set contains a certain Object?

I have two Hibernate data object. The first is a User (with unique id, username etc.) and the second is …

hibernate set hql contains

org.hibernate.QueryException: JPA-style positional param was not an integral ordinal

I have the following JPQL request; @Query(value = "select req_t " + "from TransactionRelation tr " + "inner join tr.requestTransaction req_t " + "…

java hibernate jpa hql jpql

hibernate inner select in from clause

I'd like to know if it's possible to specify a select clause in a from clause something like select count(*) …

hibernate select hql criteria

Can not set java.lang.Integer field to java.lang.Integer

User declaration: @Entity public class User { @Id @GeneratedValue private Integer id; .... Pattern declaration: @Entity public class Pattern { @Id @GeneratedValue Integer …

java hibernate persistence hql

Query to delete all rows in a table hibernate

I am trying to delete all rows in table 'user_role' with hibernate query. But every time i am getting …

hibernate hql delete-row

Hive QL - Limiting number of rows per each item

If I have multiple items listed in a where clause How would one go about limiting the results to N …

hadoop hql hive hiveql

Group by month with criteria in Hibernate

I'm trying to get a report using Criteria and ProjectionList, and I'm pretty new using this through hibernate. So I …

java hibernate hql criteria

How to view the value of a hive variable?

How do you view the value of a hive variable you have set with the command "SET a = 'B,C,…

sql apache hql hive