1 Reply Latest reply on Aug 22, 2011 10:23 AM by Sanne Grinovero

    Is Infinispan query supporting to return distinct result?

    JaeHee Roh Newbie

      Hi

       

      In SQL, we have "distinct" keyword to return unique result.

      In Hibernate, Projections is used with Criteria to return distinct result.

       

      Criteria crit = session.createCriteria(Survey.class);

      ProjectionList projList = Projections.projectionList();

      projList.add(Projections.countDistinct("Id"));

       

      But, in the case, I need to get Session.

      I am not sure how to get Session in Infinispan.

      Or is there any way to get unique result from Query module in Infinispan?

       

      Thanks.