lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Narsi <bnars...@gmail.com>
Subject Re: Select distinct records
Date Thu, 11 Feb 2016 23:22:13 GMT
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
> > > > >>
> > > > >
> > > > >
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message