Simple example of delete HQL is below :
Session session = HibernateUtil.currentSession();
String hql = "delete from Product where name = :name";
query query = session.createQuery(hql);
query.setString("name","Product 1");
int rowCount = query.executeUpdate();
System.out.println("Rows affected: " + rowCount);