You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Tiernan OToole <ls...@gmail.com> on 2011/11/04 10:41:36 UTC
Solr, MultiValues and links...
Right, not sure how to ask this question, what the terminology, but
hopefully my explaination will help...
We are chucking data into solr for queries. i cant mention the exact data,
but the closest thing i can think of is as follows:
- Unique ID for the solr record (DB ID in this case)
- A not so unique ID (say an ISBN number)
- the name of the book (multiple names for this, each have a ISBN and a
unique DB ID)
- A Status of the book (books arent the correct term, but, say, a book
has 4 editions but keeps the ISBN, we would have 4 names in Solr, each
queryable. So, searching for the first edition title will return the
correct ISBN).
Anyway, what i want to be able to do is search for a single title (say Solr
or Dummies) and find all instances of that title in index. but for each
name, i want to be able to link the status of each title with each one.
there are other "statuses" for each item also...
Anyway, i had 2 ways of doing this:
- the first way was using multi values, storing the names in a multi
value list and also the statuses, but the linking dont seem to be working
correctly...
- the second way is storing each record uniqley, but with this i would
need to run a second query to get all records for the ISBN...
Any ideas which one i should be using? any tips on this?
Thanks.
--
Tiernan O'Toole
blog.lotas-smartman.net
www.geekphotographer.com
www.tiernanotoole.ie
Re: Solr, MultiValues and links...
Posted by Tiernan OToole <ls...@gmail.com>.
That looks promising... Will look into that a bit more.
--Tiernan
On Sat, Nov 5, 2011 at 4:07 PM, Erick Erickson <er...@gmail.com>wrote:
> Hmmm, MultiValues are guaranteed to be returned in the order they were
> inserted, so you might be able to do the linking yourself given the
> results.
>
> But have you considered grouping (aka field collapsing) on the ISBN number?
> If you indexed each record uniquely, that might do what you need.
>
> Best
> Erick
>
> On Fri, Nov 4, 2011 at 5:41 AM, Tiernan OToole <ls...@gmail.com>
> wrote:
> > Right, not sure how to ask this question, what the terminology, but
> > hopefully my explaination will help...
> >
> > We are chucking data into solr for queries. i cant mention the exact
> data,
> > but the closest thing i can think of is as follows:
> >
> >
> > - Unique ID for the solr record (DB ID in this case)
> > - A not so unique ID (say an ISBN number)
> > - the name of the book (multiple names for this, each have a ISBN and a
> > unique DB ID)
> > - A Status of the book (books arent the correct term, but, say, a book
> > has 4 editions but keeps the ISBN, we would have 4 names in Solr, each
> > queryable. So, searching for the first edition title will return the
> > correct ISBN).
> >
> > Anyway, what i want to be able to do is search for a single title (say
> Solr
> > or Dummies) and find all instances of that title in index. but for each
> > name, i want to be able to link the status of each title with each one.
> > there are other "statuses" for each item also...
> >
> > Anyway, i had 2 ways of doing this:
> >
> >
> > - the first way was using multi values, storing the names in a multi
> > value list and also the statuses, but the linking dont seem to be
> working
> > correctly...
> > - the second way is storing each record uniqley, but with this i would
> > need to run a second query to get all records for the ISBN...
> >
> > Any ideas which one i should be using? any tips on this?
> >
> > Thanks.
> >
> >
> > --
> > Tiernan O'Toole
> > blog.lotas-smartman.net
> > www.geekphotographer.com
> > www.tiernanotoole.ie
> >
>
--
Tiernan O'Toole
blog.lotas-smartman.net
www.geekphotographer.com
www.tiernanotoole.ie
Re: Solr, MultiValues and links...
Posted by Erick Erickson <er...@gmail.com>.
Hmmm, MultiValues are guaranteed to be returned in the order they were
inserted, so you might be able to do the linking yourself given the results.
But have you considered grouping (aka field collapsing) on the ISBN number?
If you indexed each record uniquely, that might do what you need.
Best
Erick
On Fri, Nov 4, 2011 at 5:41 AM, Tiernan OToole <ls...@gmail.com> wrote:
> Right, not sure how to ask this question, what the terminology, but
> hopefully my explaination will help...
>
> We are chucking data into solr for queries. i cant mention the exact data,
> but the closest thing i can think of is as follows:
>
>
> - Unique ID for the solr record (DB ID in this case)
> - A not so unique ID (say an ISBN number)
> - the name of the book (multiple names for this, each have a ISBN and a
> unique DB ID)
> - A Status of the book (books arent the correct term, but, say, a book
> has 4 editions but keeps the ISBN, we would have 4 names in Solr, each
> queryable. So, searching for the first edition title will return the
> correct ISBN).
>
> Anyway, what i want to be able to do is search for a single title (say Solr
> or Dummies) and find all instances of that title in index. but for each
> name, i want to be able to link the status of each title with each one.
> there are other "statuses" for each item also...
>
> Anyway, i had 2 ways of doing this:
>
>
> - the first way was using multi values, storing the names in a multi
> value list and also the statuses, but the linking dont seem to be working
> correctly...
> - the second way is storing each record uniqley, but with this i would
> need to run a second query to get all records for the ISBN...
>
> Any ideas which one i should be using? any tips on this?
>
> Thanks.
>
>
> --
> Tiernan O'Toole
> blog.lotas-smartman.net
> www.geekphotographer.com
> www.tiernanotoole.ie
>