如何在JPA和Distinct中的两列上运行像SUM这样的聚合函数？

@Entity
@Table(name = "your_table")
public class YourEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private Integer column1;

    private Integer column2;

    // getters and setters
}

// 在某个方法中执行查询
EntityManagerFactory emf = Persistence.createEntityManagerFactory("your-persistence-unit");
EntityManager em = emf.createEntityManager();

String jpql = "SELECT SUM(e.column1), SUM(e.column2) FROM YourEntity e GROUP BY e.column1, e.column2";
Query query = em.createQuery(jpql);

List<Object[]> results = query.getResultList();
for (Object[] result : results) {
    Integer sumColumn1 = (Integer) result[0];
    Integer sumColumn2 = (Integer) result[1];
    // 处理结果
}

em.close();
emf.close();