Top "Hql" questions

What's the best way to write if/else if/else if/else in HIVE?

Hive uses IF(condition, expression, expression), so when I want to do if / else if / else if / else, I have …

hive hql

Difference between LEFT JOIN and LEFT JOIN FETCH in Hibernate?

I am trying to understand the difference between LEFT JOIN and LEFT JOIN FETCH in Hibernate. Can anyone explain this? …

hibernate hql fetching-strategy

HQL Query to check if size of collection is 0 or empty

I try to generate a HQL query that include user with a empty appoinment collections(mapped by OneToMany): SELECT u …

sql hibernate hql

org.hibernate.QueryException: illegal attempt to dereference collection

I am trying following hql query to execute SELECT count(*) FROM BillDetails as bd WHERE bd.billProductSet.product.id = 1002 AND …

hibernate hql jpa-2.0 dereference jpa-2.1

How to simulate NVL in HQL

I tried this: from Table where (:par1 is null or col1 = :par1) but it happens that from Table where :par1 …

hibernate hql

How to make this select * from two joined tables query in HQL form?

I had two hibernate entity here with annotation: @Entity @Table(name = "CLIENT") public class Client { private Long pkClient; private String …

java hibernate hql hibernate-annotations named-query

HQL left join of un-related entities

I have 2 entities, A and B. They are related but I do not want to add the relationship mapping to …

java hibernate hql left-join

HQL query with LIKE having issues

I am working on a search query using HQL and everything works find until I get to the LIKE clause. …

hibernate hql

New object with HQL

Trying to create an object from an HQL query, but just can't figure out what i'm doing wrong. Query: String …

hibernate object hql playframework

Hibernate: How to get result from query with multiple classes

If my query contains one class, like: query = session.createQuery("select u from User as u"); queryResult = query.list(); then …

java hibernate hql