Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAE4tqLO-UPz89OwSKT7-Z3U1-eAV2dy6dX3=xgHVfmPEJvBG2Q@mail.gmail.com>
References: 
 <CAKhpE5mnj1fyDEDRqaXtSpQJFHttUEyos-vmOo64Qjc4gsvbhg@mail.gmail.com>
	<CALGoTy1y0Mfyfk1rc4OJZcanRF8U_6QcF6K+2aa0RWGg9Nhx9A@mail.gmail.com>
	<CAKhpE5k7eVc3V94UUnunbiTC0nqon8e2xi-S+8gQ6--xUAfMSg@mail.gmail.com>
	<CAKhpE5kA32tikMxMeirxztc2UOLmMQzVBD31vy-cVpsDe0ZtOQ@mail.gmail.com>
	<CAE4tqLNXCJjbzL5H4pHwFw8nMqYXR1m8JQ0uF0Orgyo+pKejEw@mail.gmail.com>
	<CAKhpE5kwc8ypot2Lyw8MLMA_DfxeORsJV75SAgQNU-DjNZRd_A@mail.gmail.com>
	<CAE4tqLO-UPz89OwSKT7-Z3U1-eAV2dy6dX3=xgHVfmPEJvBG2Q@mail.gmail.com>
Date: Thu, 11 Feb 2016 17:22:13 -0600
Message-ID: 
 <CAKhpE5nJsX+yHDGgsJGCrSkMukohNKOCxdQG1hBVjp9ZVAs7_Q@mail.gmail.com>
Subject: Re: Select distinct records
From: Brian Narsi <bnarsi70@gmail.com>
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=001a11c3b44e0fae5d052b86d26d

--001a11c3b44e0fae5d052b86d26d
Content-Type: text/plain; charset=UTF-8

In order to use the Collapsing feature I will need to use Document Routing
to co-locate related documents in the same shard in SolrCloud. What are the
advantages and disadvantages of Document Routing?

Thanks,

On Thu, Feb 11, 2016 at 12:54 PM, Joel Bernstein <joelsolr@gmail.com> wrote:

> Yeah that would be the reason. If you want distributed unique capabilities,
> then you might want to start testing out 6.0. Aside from SELECT DISTINCT
> queries, you also have a much more mature Streaming Expression library
> which supports the unique operation.
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Thu, Feb 11, 2016 at 12:28 PM, Brian Narsi <bnarsi70@gmail.com> wrote:
>
> > Ok I see that Collapsing features requires documents to be co-located in
> > the same shard in SolrCloud.
> >
> > Could that be a reason for duplication?
> >
> > On Thu, Feb 11, 2016 at 11:09 AM, Joel Bernstein <joelsolr@gmail.com>
> > wrote:
> >
> > > The CollapsingQParserPlugin shouldn't have duplicates in the result
> set.
> > > Can you provide the details?
> > >
> > > Joel Bernstein
> > > http://joelsolr.blogspot.com/
> > >
> > > On Thu, Feb 11, 2016 at 12:02 PM, Brian Narsi <bnarsi70@gmail.com>
> > wrote:
> > >
> > > > I have tried to use the Collapsing feature but it appears that it
> > leaves
> > > > duplicated records in the result set.
> > > >
> > > > Is that expected? Or any suggestions on working around it?
> > > >
> > > > Thanks
> > > >
> > > > On Thu, Feb 11, 2016 at 9:30 AM, Brian Narsi <bnarsi70@gmail.com>
> > wrote:
> > > >
> > > > > I am using
> > > > >
> > > > > Solr 5.1.0
> > > > >
> > > > > On Thu, Feb 11, 2016 at 9:19 AM, Binoy Dalal <
> binoydalal93@gmail.com
> > >
> > > > > 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 <bnarsi70@gmail.com>
> > > 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
> > > > >>
> > > > >
> > > > >
> > > >
> > >
> >
>

--001a11c3b44e0fae5d052b86d26d--