Hi,
I am doing hibernate search with Lucene,
I want to get count of distinct userId and count of tweets from the lucene result
see the below code:

Criteria joinCriteria =session.createCriteria(MBlogLiveTweetVO.class)
.setProjection(Projections.projectionList().add(Projections.countDistinct("userId"))
.add(Projections.count("tweet")));
FullTextQuery fullTextQuery = fSession.createFullTextQuery(lucenceQuery).setCriteriaQuery(joinCriteria);
System.out.println("Result -->"+fullTextQuery.list());
Also i enabled show_sql =true in hibernatec.fg.xml file to verify the result.

The output result is Zero record.but record is there If i execute printed SQL query (like below)
select count(distinct this_.user_id) as y0_ from mblog_live_tweets this_ where (this_.tweet_id in (?))

Kindly let me know what's the problem with my code.

What you are doing is actually not supported. Criterias should only be used to specify the fetch mode for joins. The documentation says:





We always recommend to index all the information you need to solve your search requirements via Lucene queries. Also don't get confused between Hibernate Core porjections and Hibernate Search projections. These are different beasts.
I recommend you have another look at the Hibernate Search docs.

--Hardy