Have you investigated 'field collapsing'? I believe that it is a least the 'DISTINCT' part.
Dennis Gearon Signature Warning ---------------- It is always a good idea to learn from your own mistakes. It is usually a better idea to learn from others’ mistakes, so you do not have to make them yourself. from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036' EARTH has a Right To Life, otherwise we all die. ----- Original Message ---- From: dan sutton <danbsut...@gmail.com> To: solr-user <solr-user@lucene.apache.org> Sent: Wed, December 22, 2010 1:29:23 AM Subject: solr equiv of : SELECT count(distinct(field)) FROM index WHERE length(field) > 0 AND other_criteria Hi, Is there a way with faceting or field collapsing to do the SQL equivalent of SELECT count(distinct(field)) FROM index WHERE length(field) > 0 AND other_criteria i.e. I'm only interested in the total count not the individual records and counts. Cheers, Dan
