lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aman Tandon <antn.s...@gmail.com>
Subject Re: retreive all the fields in join
Date Tue, 13 May 2014 18:04:06 GMT
Thanks Walter yeah we are now trying to use the external file field as
mentioned by you.
On May 12, 2014 11:11 PM, "Walter Underwood" <wunder@wunderwood.org> wrote:

> Top management has given requirements that force a broken design. They are
> requiring something that is impossible with Solr.
>
> 1. Flatten the data. You get one table, no joins.
>
> 2. 12M records is not a big Solr index. That should work fine.
>
> 3. If the supplier activity points are updated frequently, you could use
> an external file field for those, but they still need to be flattened.
>
> wunder
>
> On May 12, 2014, at 7:21 AM, Aman Tandon <antn.solr@gmail.com> wrote:
>
> > Yeah i understand but i got the requirement from the top management,
> > requirements are:
> > core1:  in this we want to keep the supplier activity points
> > case 2: we want to boost those records which are present in core1 by the
> > amount of supplier activity points.
> >
> > I know we can keep that supplier score in same core but this requires the
> > full indexing of 12M records and suppliers are of about 1lacs which won't
> > cost much.
> >
> > With Regards
> > Aman
> >
> >
> > On Mon, May 12, 2014 at 7:44 PM, Erick Erickson <erickerickson@gmail.com
> >wrote:
> >
> >> Any time you find yourself trying to use Solr like a DB, stop.
> >>
> >> Solr joins are _not_ DB joins, the data from the "from" core is not
> >> returned (I think there are a few special cases where you can make
> >> this happen though).
> >>
> >> Try denormalizing your data if at all possible, that's what Solr docs
> >> best... search single records.
> >>
> >> Best,
> >> Erick
> >>
> >> On Sun, May 11, 2014 at 6:40 PM, Aman Tandon <amantandon.10@gmail.com>
> >> wrote:
> >>> please help me out here!!
> >>>
> >>> With Regards
> >>> Aman Tandon
> >>>
> >>>
> >>> On Sun, May 11, 2014 at 1:44 PM, Aman Tandon <amantandon.10@gmail.com
> >>> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> Is there a way possible to retrieve all the fields present in both the
> >>>> cores(core 1 and core2).
> >>>>
> >>>> e.g.
> >>>> core1: {id:111,name: "abc" }
> >>>>
> >>>> core2: {page:17, type: "fiction"}
> >>>>
> >>>> I want is that, on querying both the cores I want to retrieve the
> >> results
> >>>> containing all the 4 fields, fields id, name from core1 and page, type
> >> from
> >>>> core2. Is it possible?
> >>>>
> >>>> With Regards
> >>>> Aman Tandon
> >>>>
> >>
>
> --
> Walter Underwood
> wunder@wunderwood.org
>
>
>
>

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