Solr 6.0 supports SELECT DISTINCT (SQL) queries. You can even choose between a MapReduce implementation and a Json Facet implementation. The MapReduce Implementation supports extremely high cardinality for the distinct fields. Json Facet implementation supports lower cardinality but high QPS.
Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Feb 11, 2016 at 10:30 AM, Brian Narsi <[email protected]> wrote: > I am using > > Solr 5.1.0 > > On Thu, Feb 11, 2016 at 9:19 AM, Binoy Dalal <[email protected]> > wrote: > > > What version of Solr are you using? > > Have you taken a look at the Collapsing Query Parser. It basically > performs > > the same functions as grouping but is much more efficient at doing it. > > Take a look here: > > > > > https://cwiki.apache.org/confluence/display/solr/Collapse+and+Expand+Results > > > > On Thu, Feb 11, 2016 at 8:44 PM Brian Narsi <[email protected]> wrote: > > > > > I am trying to select distinct records from a collection. (I need > > distinct > > > name and corresponding id) > > > > > > I have tried using grouping and group format of simple but that takes a > > > long time to execute and sometimes runs into out of memory exception. > > > Another limitation seems to be that total number of groups are not > > > returned. > > > > > > Is there another faster and more efficient way to do this? > > > > > > Thank you > > > > > -- > > Regards, > > Binoy Dalal > > >
