lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dariusz Borowski <darius...@gmail.com>
Subject Re: configuring schema to match database
Date Fri, 11 Jan 2013 14:30:29 GMT
I don't know how to query multiple cores and if it's possible at once, but
otherwise I would create a JOIN sql script if you need values from multiple
tables.

D.



On Fri, Jan 11, 2013 at 3:27 PM, Niklas Langvig <
niklas.langvig@globesoft.com> wrote:

> Ahh sorry,
> Now I understand,
> Ok seems like a good solution, I just know need to understand how to query
> multiple cores now :)
>
> -----Ursprungligt meddelande-----
> Från: Dariusz Borowski [mailto:dariusz.b@gmail.com]
> Skickat: den 11 januari 2013 15:15
> Till: solr-user@lucene.apache.org
> Ämne: Re: configuring schema to match database
>
> Hi,
>
> No, it has actually two tables. User and Item. The example shown on the
> blog is for one table, because you repeat the same thing for the other
> table. Only your data-import.xml file changes. For the rest, just copy and
> paste it in the conf directory. If you are running your solr in Linux, then
> you can work with symlinks.
>
> D.
>
>
>
> On Fri, Jan 11, 2013 at 3:12 PM, Niklas Langvig <
> niklas.langvig@globesoft.com> wrote:
>
> > Hi Dariusz,
> > To me this  example has one table "user" and I have many tables that
> > connects to one user and that is what I'm unsure how how to do.
> >
> > /Niklas
> >
> >
> > -----Ursprungligt meddelande-----
> > Från: Dariusz Borowski [mailto:dariusz.b@gmail.com]
> > Skickat: den 11 januari 2013 14:56
> > Till: solr-user@lucene.apache.org
> > Ämne: Re: configuring schema to match database
> >
> > Hi Niklas,
> >
> > Maybe this link helps:
> >
> > http://www.coderthing.com/solr-with-multicore-and-database-hook-part-1
> > /
> >
> > D.
> >
> >
> >
> > On Fri, Jan 11, 2013 at 2:19 PM, Niklas Langvig <
> > niklas.langvig@globesoft.com> wrote:
> >
> > > Hi!
> > > I'm quite new to solr and trying to understand how to create a
> > > schema from how our postgres database and then search for the
> > > content in solr instead of querying the db.
> > >
> > > My question should be really easy, it has most likely been asked
> > > many times but still I'm not able to google any answer to it.
> > >
> > > To make it easy, I have 3 columns: users, courses and languages
> > >
> > > Users has columns , userid, firstname, lastname Courses has column
> > > coursename, startdate, enddate Languages has column language,
> > > writingskill, verbalskill
> > >
> > > UserA has taken courseA, courseB and courseC and has writingskill
> > > good verbalskill good for english and writingskill excellent
> > > verbalskill excellent for spanish UserB has taken courseA, courseF,
> > > courseG and courseH and has writingskill fluent verbalskill fluent
> > > for english and writingskill good verbalskill good for italian
> > >
> > > I would like to put this data into solr so I can search for all
> > > "users how have taken courseA and are fluent in english".
> > > Can I do that?
> > >
> > > The problem is I'm not sure how to flatten this database into a
> > > schema It's easy to understand the users column, for example <field
> > > name="userid" type="string" indexed="true" /> <field name="firstname"
> > > type="string" indexed="true" /> <field name="lastname" type="string"
> > > indexed="true" />
> > >
> > > But then I'm not so sure how the schema should look like for courses
> > > and languages <field name="userid" type="string" indexed="true" />
> > > <field name="coursename" type="string" indexed="true" /> <field
> > > name="startdate" type="string" indexed="true" /> <field name="enddate"
> > > type="string" indexed="true" />
> > >
> > >
> > > Thanks for any help
> > > /Niklas
> > >
> >
>

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